Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

Replace sting

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

1 Solution

Accepted Solutions
qlik_aparnav
Contributor II

Re: Replace sting

try this,

load id+0 as new;

load * inline [

id

000574

0574

02540];

6 Replies

Re: Replace sting

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

qlik_aparnav
Contributor II

Re: Replace sting

try this,

load id+0 as new;

load * inline [

id

000574

0574

02540];

Re: Replace sting

May be this

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

souadouert
Contributor III

Re: Replace sting

i want delete just the zero at the beginning 

souadouert
Contributor III

Re: Replace sting

thank you

Re: Replace sting

Multiply with 1 to field

Community Browser