On Tue, 2008-09-16 at 15:37 -0500, Robert Citek wrote:
> How can I replace an underscore ("_") in a field with a tab?
>
> I have a field in a sqlite3 table that looks similar to this:
> a_1
> b_2
> c_3
> ...
>
> I would like to replace the underscore with a tab not in the database
> itself, but rather just in the output. Unfortunately, this does not
> work:
>
> $ sqlite3 foobar.db 'select replace(id,"_",\t) from bar;'
>
> 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.
Maybe use this conversion table, and do your search and replace in
hexadecimal?
Theresa
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
