topic Remove Three Zeros and Remove the Comma Separator in QlikView

Remove Three Zeros and Remove the Comma Separator

pandreozzi — Mon, 26 Feb 2018 13:11:47 GMT

I have two questions for those who are developers as I am not.

First:

I have a series of numbers: These are just examples each are independent and being read from an excel spreadsheet.

80000

100000

20000

I want to remove the three (3) trailing zeros to have them display

100

Second:

I also have a series of numbers as follows.

080,000

0041,211

0002,738

I need to remove the leading zeros and the comma separator

Once done I am going to calculate the two numbers to get an average so a/b=c

Any suggestions is well appreciated

fvelascog72 — Mon, 26 Feb 2018 13:22:15 GMT

Hi,

For case 1 try:

Mid(DATA1, 1, Len(DATA1) -3)

For case 2 try:

Num(PurgeChar(DATA2, Chr(44)))

Saludos.

pandreozzi — Mon, 26 Feb 2018 13:33:08 GMT

Thanks Federico. I will try this and let you know the results.

pandreozzi — Mon, 26 Feb 2018 16:08:29 GMT

Works great. Thanks Federico.