sql - sqlite replace() function to perform a string replace -


I have a column in a SQL database that I need to modify.

The array that looks like this:

  0.021460.04419,0.04551,0.02734,0.011,0.005  

A comma between the first and second values ​​in the array Is missing, so the array should look like this:

  0.02146,0.04419,0.04551,0.02734,0.011,0.005  

Data value never greater than 0.9 That's why I'm trying to create an updated query Number two "0." To replace a string, it will use the replacement () function to replace. And by changing it from ", 0", but I do not know how to do it.

Just all 0 incidents : < Replace / p>

  (TheColumn, '0.', ', 0')  

Then delete the duplicate:

  Replace (cc, '0.', ', 0'), ',', ',')  

and commas in the beginning:

  Substr (replace, copy, '0.', ', 0'), ',', ',', '), 2)  

Comments

Popular posts from this blog

Member with no value in F# -

java - Joda Time Interval Not returning what I expect -

c# - Showing a SelectedItem's Property -