Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

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
Anonymous
Not applicable

try this,

load id+0 as new;

load * inline [

id

000574

0574

02540];

View solution in original post

6 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

try this,

load id+0 as new;

load * inline [

id

000574

0574

02540];

sunny_talwar

May be this

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

souadouert
Specialist
Specialist
Author

i want delete just the zero at the beginning 

souadouert
Specialist
Specialist
Author

thank you

Anil_Babu_Samineni

Multiply with 1 to field

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)