On Tue, Sep 16, 2008 at 4:17 PM, Robert Citek <[EMAIL PROTECTED]> wrote: > On Tue, Sep 16, 2008 at 3:43 PM, David Dooling >> 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;'
And one more rather obscure version that works: $ sqlite3 foobar.db 'select replace(id,"_",cast(x"09" as text)) from bar;' 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 -~----------~----~----~----~------~----~------~--~---
