Removing Zero's in a number

[Prudhvib]

Dear guys,

I have a sample number of 0000123456000.

So how can I get the number only 123456?

Please any tips from anyone.

[mikaelsc · Accepted solution]

purgechar(number,'0')

keepchar(number,'123456789')

...

[Prudhvib · Accepted solution]

Thank you @mikaelsc for quick response and solution , great 👌

[ratnadeep · Accepted solution]

@Prudhvib I encountered similar situation, but the number had 0 in between other digits (example 000012304000 and i was asked to extract 5 digit 12304 )

below is my approach. I have attached the output i achieved

test:
load * inline [

testnum
00012304000
00224580000
0000456780
012005000
];

for j = 0 to NoOfRows('test')

let vtest = peek('testnum',$(j),'test');
let vLenTest = len(peek('testnum',$(j),'test'));

for i = 0 to $(vLenTest)

if (left('$(vtest)',$(i))>0) then

temp:
Load
mid($(vtest),$(i),5) as extract1
AutoGenerate 1;
let i = $(vLenTest);
end if;

next i;

next j;

for k =0 to NoOfRows('test')
Output:
Load
peek('testnum',$(k),'test') as testnum,
peek('extract1',$(k),'temp') as output1
AutoGenerate 1;
next k;

drop tables temp,test;

[rwunderlich · Accepted solution]

A clever solution I have seen in this forum for removing leading and trailing zeros while maintaining embedded zeros is:

Replace(Trim(Replace(testnum, '0', ' ')), ' ', '0')

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Prudhvib]

Great @ratnadeep , expecting your contribution on this community more in future, thank you.

[Prudhvib]

Sure @rwunderlich , thank you for your solution 🤝.

[ratnadeep]

Great help @rwunderlich !!! thank you very much.