Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
pandreozzi
Creator
Creator

Remove Three Zeros and Remove the Comma Separator

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

10

100

20

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

1 Solution

Accepted Solutions
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

For case 1 try:

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

For case 2 try:

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

Saludos.

View solution in original post

3 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

For case 1 try:

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

For case 2 try:

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

Saludos.

pandreozzi
Creator
Creator
Author

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

pandreozzi
Creator
Creator
Author

Works great. Thanks Federico.