On 8/8/06, wqual <[EMAIL PROTECTED]> wrote:
Hi Donald, thanks for this valuable comment. Regarding the regexp-function, I am not really sure whether I understood it entirely or not: is it correct that I can use the regexp *only* in external programs (e.g. a perl programme), but not on the sqlite command line? There is no possibility to activate regexp also for the sqlite-command line? Sorry for asking these questions
I think he was suggesting this: 1. sqlite command line exports from the database to a file. 2. edit the file using perl, vi, elm, sed, ed, awk, etc. 3. reload the file to the database
I am using sqlite on the command-line and via sqlitebrowser - and I am no programmer (hm.). Unfortunately, the substr-function won't do the job in my case, as the position of substrings may vary within my tables.
regular expressions can probably do this, though it might take someone very familiar with them to make it work. It's fairly simple to edit the Nth substring in a string.