Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
sparur
Specialist II
Specialist II

How I can remove leading zeroes

Hello, colleagues.I have a small problem, which I can't resolve elegant.

I want to remove leading zeroes from my Data.

I tried to do some text / num converting, but it didn't help me.

See attached file

31 Replies
berndjaegle
Creator II
Creator II

Very nice. Thanks Rakesh.

brooksc57
Creator
Creator

awesome!!!!

ruben_antelo
Partner - Contributor III
Partner - Contributor III

Hi Anatoly,

Just one more possible solution for future readers...

num( EVALUATE(FieldToDeleteLeadingZeros),'#0') as MyNumber

Not applicable

I guess this is an old thread, but I remove leading zeroes by replacing them with blanks and then using ltrim on load like this:

replace(ltrim(replace(FIELDNAME,'0',' ')),' ','0')

It seems to work and is pretty elegant.

Not applicable

I use this formula:  replace(ltrim(replace(FIELDNAME,'0',' ')),' ','0')

and it seems to work.

Anonymous
Not applicable

Hi Rakesh,

Nice to see you here!. Was looking for a solution to this and found your answer, however I think this won't work for all scenarios.

If I have a material number: 00-001-002, this solution will return -001-002 therefore I enhance a little bit your already elegant solution:

if(purgechar(MATNR,' 0123456789') = '',replace(ltrim(replace(MATNR, '0', ' ')), ' ', 0),MATNR)

Regards,

Cesar

Anonymous
Not applicable

Thanks. This worked well for me

andy
Partner - Creator III
Partner - Creator III

I use

num(num#(FieldName))

pentaxadmin
Partner - Creator
Partner - Creator

I use EVALUATE([FieldName] & '* 1') as replace(ltrim(replace(FIELDNAME,'0',' ')),' ','0') was also removing 0 inside the string, not just leading 0s

JustinDallas
Specialist III
Specialist III

What on earth does that * 1 do?