On Tue, Sep 16, 2008 at 3:43 PM, David Dooling <[EMAIL PROTECTED]> wrote: > Would the above work if you put \t in double quotes, "\t"?
Nope. a_1 becomes a\t1 > Would it work if you actually put a tab character (C-v C-i in most shells) > inbetween double quotes for the third argument to replace()? That worked. Needed the double quotes, which I didn't have when I tried that before. Discovered that this also worked in bash, although the quoting is ugly: $ sqlite3 foobar.db 'select replace(id,"_","'$'\t''") from bar;' Thanks, David. Regards, - Robert --~--~---------~--~----~------------~-------~--~----~ Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] More options: http://groups.google.com/group/cwelug -~----------~----~----~----~------~----~------~--~---
