Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

Hi Jay, list. Many thanks for your comments. In many cases, exporting the table as a textfile and using sed to search and replace will be a very good solution. Thanks! But Jay: how can I implement a function "MyFunction" like in your example? Could you give me a hint? That would be really great!

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

On 8/8/06, Olaf Beckman Lapré <[EMAIL PROTECTED]> wrote: 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

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

: "Jay Sprenkle" <[EMAIL PROTECTED]> To: 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. Re

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

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

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 ac

RE: [sqlite] Replace of substring in sqlite-table - how can I do this?

Hi Wolfgang, Regarding: "...thank you very much for your reply. But is there no command within sqlite to do this? In my case, only substrings of the cells of one column need to be changed!" Sqlite was designed as a small SQL library -- extremely small, considering its capabilities -- implementin

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

Hi Peter, thank you very much for your reply. But is there no command within sqlite to do this? In my case, only substrings of the cells of one column need to be changed! Best regards, Wolfgang Am Montag 07 August 2006 pH:19:16 nachmittags/abends schrieb Peter Cunderlik: > On 8/7/06, wqual <[E

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

On 8/7/06, wqual <[EMAIL PROTECTED]> wrote: Hi list, I have sqlite 3.2.1 installed on my computer. Now, I need to replace some substrings in my sqlite-table (for example, replace 'strasse' with 'str.' , german 'ä' with 'ae' etc.). Can I search for the substrings and replace them by another one? I

[sqlite] Replace of substring in sqlite-table - how can I do this?

Hi list, I have sqlite 3.2.1 installed on my computer. Now, I need to replace some substrings in my sqlite-table (for example, replace 'strasse' with 'str.' , german 'ä' with 'ae' etc.). Can I search for the substrings and replace them by another one? I do not know, what would be the right synta