topic Trim zeros in QlikView

Trim zeros

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a field and it has data like 002,003,096,099..

Here i need to remove only zeros.

The final required output would be 2,3,96,99

Field : Location

Thanks..

Re: Trim zeros

m_woolf — Fri, 10 Feb 2017 16:35:58 GMT

see the replace() string function in Help

Re: Trim zeros

albertovarela — Fri, 10 Feb 2017 16:51:44 GMT

Try replace(ltrim(replace(YourField,'0',' ')),' ','0')

Re: Trim zeros

Anonymous — Fri, 10 Feb 2017 16:59:50 GMT

You could try this if you field has numbers and letters:

if(isnum(YourField),num(YourField),YourField)

If you're certain the data will always be numeric than you would just need num(YourField)

Re: Trim zeros

cmsjamesgreen — Fri, 10 Feb 2017 17:26:09 GMT

Try a combination of Mid() and FindOneOf()

=Mid(Location, FindOneOf(Location, '123456789'))

Re: Trim zeros

Peter_Cammaert — Fri, 10 Feb 2017 17:28:22 GMT

Or if you cannot rely on the default masks, you can also use an explicit format that does away with the leading zeroes:

=num(Field, '#0')

Re: Trim zeros

jonas_rezende — Fri, 10 Feb 2017 17:54:05 GMT

Hi, nareshthavidishetty nareshthavidishetty.

Try simply num(Field).

I hope this helps.

Re: Trim zeros

MarcoWedel — Fri, 10 Feb 2017 22:57:44 GMT

or maybe

Location*1

hope this helps

regards

Marco

Re: Trim zeros

Anil_Babu_Samineni — Sat, 11 Feb 2017 01:25:15 GMT

What is the output you want to see for below Input

Load * Inline [

Location

001

002

300

400

030

099

330

];

Expected output please?

Re: Trim zeros

sdmech81 — Sat, 11 Feb 2017 02:37:35 GMT

Hi,

May be try =num(yourfiled)

if doesn't work then plss use like

=Right(yourfield,1)

Sachin