topic Re: Replace sting in QlikView

Replace sting

souadouert — Wed, 10 Jan 2018 08:41:50 GMT

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

Anil_Babu_Samineni — Wed, 10 Jan 2018 08:44:53 GMT

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

Anonymous — Wed, 10 Jan 2018 08:46:06 GMT

try this,

load id+0 as new;

load * inline [

000574

0574

02540];

sunny_talwar — Wed, 10 Jan 2018 08:47:35 GMT

May be this

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

souadouert — Wed, 10 Jan 2018 08:50:09 GMT

i want delete just the zero at the beginning

souadouert — Wed, 10 Jan 2018 08:50:59 GMT

thank you

Anil_Babu_Samineni — Wed, 10 Jan 2018 08:51:17 GMT

Multiply with 1 to field