Hi, If I have a text with something like... "A=1 A=2 A=3 A=4" I want to replace all the instance of "A=num" with "B=num*num", (the square root of the number after A) So that in the example above "A=1 A=2 A=3 A=4" Would become "B=1 B=4 B=9 B=16" If I run a simple recurring update it does not work. UPDATE tableA SET contentA = REPLACE ( contentA, 'A=', 'B=' ); Would of course only replace 'A=' and give me: "B=1 B=2 B=3 B=4" So, how can I do a recurring search and replace the value and the text after what ...
Hi,
If I have a text with something like...
"A=1 A=2 A=3 A=4"
I want to replace all the instance of "A=num" with "B=num*num", (the square
root of the number after A)
So that in the example above
"A=1 A=2 A=3 A=4"
Would become
"B=1 B=4 B=9 B=16"
If I run a simple recurring update it does not work.
UPDATE tableA SET contentA = REPLACE (
contentA,
'A=',
'B=' );
Would of course only replace 'A=' and give me:
"B=1 B=2 B=3 B=4"
So, how can I do a recurring search and replace the value and the text after
what I am searching for?
many thanks
Simon
Bookmarks