Extract notes from Notes.app

extract-notes.sh

#!/usr/bin/bash
set -euxo pipefail

SQLITE=/Volumes/Macintosh\ HD/usr/bin/sqlite3
XXD=/Volumes/Macintosh\ HD/usr/bin/xxd
GZIP=/Volumes/Macintosh\ HD/usr/bin/gzip

NOTES_DB=NoteStore.sqlite

"${SQLITE}" ${NOTES_DB} 'select quote(zdata) from zicnotedata where zdata is not null' > notes-raw.txt
awk -F\' '{print $2}' notes-raw.txt > notes-raw-stripped.txt
tr '[A-Z]' '[a-z]' < notes-raw-stripped.txt > notes-raw-stripped-lower.txt

NOTE_ID=1

while read NOTE; do
    NOTE_HEX=$(sed "${NOTE_ID}q;d" notes-raw-stripped-lower.txt)
    echo ${NOTE_HEX} | "${XXD}" -r -p > note-${NOTE_ID}.gz
    "${GZIP}" -d note-${NOTE_ID}.gz

    NOTE_ID=$((NOTE_ID+1))
done < notes-raw-stripped-lower.txt