this is what i want
this should not happen
please help me to solve this … 990is an error
This is working as you have written it. It is looking for any “0” and replacing it with “90” because it is not looking for the value of thr number it is looking for all insatnces of the “0”
You can try like the solution in this thread to use code block to have s replace condition if the string == instead of part of.
1 Like
yes, its working but i want to swap between “0” & “90”, so that where there is “0” it becomes “90” & “90” becomes “0”
If one contains the other, replace by condition instead maybe, where the condition is 90.
Try this in a codeblock after your numbers:
x == 0 ? 90 : x
Convert your strings to numbers for better options.
Alternatively if you prefer not to use numbers, replace 90 with a placeholder first such as “x”, then replace 0, then replace the x with 90 again.
2 Likes
A quick code block:
x == 90 ? 0 : x==0? 90: x;
3 Likes