How can I replace an underscore ("_") in a field with a tab?
This works but seems like suck a hack:
$ sqlite3 foobar.db 'select replace(id,"_","{tab}") from bar;' |
sed -e 's/{tab}/\t/'
I was hoping for a char(9) or similar but couldn't find anything in the docs:
http://www.sqlite.org/lang_corefunc.html
Pointers to references greatly appreciated.
Regards,
- Robert
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
