View Single Post
Old 12-21-2011, 10:36 AM   #2
ewandeep
Zealot
ewandeep , Klaatu Barada Niktu!ewandeep , Klaatu Barada Niktu!ewandeep , Klaatu Barada Niktu!ewandeep , Klaatu Barada Niktu!ewandeep , Klaatu Barada Niktu!ewandeep , Klaatu Barada Niktu!ewandeep , Klaatu Barada Niktu!ewandeep , Klaatu Barada Niktu!ewandeep , Klaatu Barada Niktu!ewandeep , Klaatu Barada Niktu!ewandeep , Klaatu Barada Niktu!
 
Posts: 110
Karma: 5368
Join Date: Apr 2010
Location: Italy
Device: Sony PRS-T1 Sony PRS-350 Nook Touch Glow
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
ewandeep is offline   Reply With Quote