Re: [sqlite] Making string changes in a table

On 09 Mar 2014 at 22:48, Igor Tandetnik wrote: > On 3/9/2014 6:37 PM, Tim Streater wrote: >> Dammit, I looked up and down for 'strlen' and passed over 'length'! I had >> been thinking about: >> >>update mytable set path='/path/from/' || substr(path, length('/path/to/')

Re: [sqlite] Making string changes in a table

On 3/9/2014 6:37 PM, Tim Streater wrote: Dammit, I looked up and down for 'strlen' and passed over 'length'! I had been thinking about: update mytable set path='/path/from/' || substr(path, length('/path/to/') + 1) where path like '/path/to/%'; that way I anchor to the start of the

Re: [sqlite] Making string changes in a table

On 09 Mar 2014 at 22:17, Igor Tandetnik wrote: > On 3/9/2014 6:05 PM, Tim Streater wrote: >> I have a table with one column containing file paths, such as /path/to/file >> and /path/to/my/otherfile. Now I want to change all entries where the path >> starts as /path/to/ to

Re: [sqlite] Making string changes in a table

On 3/9/2014 6:05 PM, Tim Streater wrote: I have a table with one column containing file paths, such as /path/to/file and /path/to/my/otherfile. Now I want to change all entries where the path starts as /path/to/ to /path/from/. Getting a candidate list is easy, and I can then make the changes

Re: [sqlite] Making string changes in a table

On 3/9/14, Simon Slavin wrote: > Check out REPLACE(): > > Technically speaking this might mess up if the string '/path/to/' occurs in > the middle of the string as well as at its beginning, For that reason, I think it would be better to use the substr function. Ambrus

Re: [sqlite] Making string changes in a table

On 9 Mar 2014, at 10:05pm, Tim Streater wrote: > I have a table with one column containing file paths, such as /path/to/file > and /path/to/my/otherfile. Now I want to change all entries where the path > starts as /path/to/ to /path/from/. Getting a candidate list is