topic Re: Removing Zero's in a number in App Development

Removing Zero's in a number

Prudhviqliks — Fri, 15 Nov 2024 20:58:11 GMT

Dear guys,

I have a sample number of 0000123456000.

So how can I get the number only 123456?

Please any tips from anyone.

Re: Removing Zero's in a number

mikaelsc — Thu, 16 May 2024 17:38:19 GMT

purgechar(number,'0')

keepchar(number,'123456789')

...

Re: Removing Zero's in a number

Prudhviqliks — Thu, 16 May 2024 17:48:32 GMT

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

Re: Removing Zero's in a number

ratnadeep — Thu, 16 May 2024 21:50:59 GMT

@Prudhviqliks 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;

Re: Removing Zero's in a number

rwunderlich — Thu, 16 May 2024 22:03:55 GMT

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

Re: Removing Zero's in a number

Prudhviqliks — Fri, 17 May 2024 01:56:16 GMT

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

Re: Removing Zero's in a number

Prudhviqliks — Fri, 17 May 2024 01:57:44 GMT

Sure @rwunderlich , thank you for your solution 🤝.

Re: Removing Zero's in a number

ratnadeep — Fri, 17 May 2024 04:32:45 GMT

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