Solved: Replace sting - Qlik Community

souadouert · ‎2018-01-10

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

Anonymous · ‎2018-01-10

try this,

load id+0 as new;

load * inline [

id

000574

0574

02540];

View solution in original post

Anil_Babu_Samineni · ‎2018-01-10

Why second row only should change? Because, Of only one 0 is there?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2018-01-10

try this,

load id+0 as new;

load * inline [

id

000574

0574

02540];

sunny_talwar · ‎2018-01-10

May be this

Replace(LTrim(Replace(String, '0', ' ')), ' ', '0') as String

souadouert · ‎2018-01-10

i want delete just the zero at the beginning

souadouert · ‎2018-01-10

thank you

Anil_Babu_Samineni · ‎2018-01-10

Multiply with 1 to field

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful