openSUSE Paste > import_sms
Login

Info:

By michal, 8 Months ago, written in Bash. This post will never expire.

URL: http://susepaste.org/49179811

  1. #!/bin/sh
  2. sqlite3 "$1" \
  3. "select address,type,datetime(date/1000, 'unixepoch','localtime'),datetime(date/1000, 'unixepoch','localtime'),body from sms;" | \
  4. sed -e 's;^\([^|]\+\)|1|\(.*\);\1|IN|\2;' -e 's;^\([^|]\+\)|2|\(.*\);\1|OUT|\2;' | \
  5. sed 's/|/;/g'
  6.