How would this compare to the performance of simply (progammatically) doing an UPDATE and changing the values in a callback hook. If this is impossbile than even a SELECT with a callback where one does an UPDATE for each returned row would be possible.
Olaf ----- Original Message ----- From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, August 08, 2006 3:35 PM Subject: Re: [sqlite] Replace of substring in sqlite-table - how can I do this? > 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. >
