|
Wonderful!!!
For very lazy people, version for MAcOS:
#!/bin/bash -vx
OUTPUT_FILE='quotes.txt'
SQLITE='sqlite3'
AWK='awk'
ICONV='iconv'
#add the UTF-8 BOM to the generated file
echo -ne '\xEF\xBB\xBF' > $OUTPUT_FILE
$SQLITE Sony_Reader/database/books.db 'select b.author, b.title, a.marked_text FROM annotation a INNER JOIN books b on a.content_id=b._id' | \
$AWK -F '|' '{ print "--------------------\nAuthor: "$1"\nTitle: "$2"\n--------------------\n"$3"\n--------------------" }'| \
$ICONV -t UTF-8 -f UTF-8 >> $OUTPUT_FILE
|