Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to replace zero with '' in the IDs, but just zero at the beginning of the ID in load script
000574 ---> 574
0574-->547
02540 -->2540
Why second row only should change? Because, Of only one 0 is there?
try this,
load id+0 as new;
load * inline [
id
000574
0574
02540];
May be this
Replace(LTrim(Replace(String, '0', ' ')), ' ', '0') as String
i want delete just the zero at the beginning
thank you
Multiply with 1 to field