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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to Remove a comma from a Dollar Amount Value using a String Method in tMap

I have an Input Field in my tMap that has dollar values like $1,000 $10,000 etc. I need to remove the commas and $ sign so the value is just 1000 or 10000.

How would I do this in a tMap Expression. Currently I have the String Method that will remove the $ sign but not the comma. How can I adjust this string method to not include commas in the output. 

 

row1.GiftAmount.replaceAll("[^\\d\\.\\,\\s]+", "") 

 

Please Advise

 

Thanks,

 

Andrew

Labels (2)
1 Solution

Accepted Solutions
akumar2301
Specialist II
Specialist II

Try this row1.GiftAmount.replaceAll("[^\\d\\.\\s]+", "")

View solution in original post

1 Reply
akumar2301
Specialist II
Specialist II

Try this row1.GiftAmount.replaceAll("[^\\d\\.\\s]+", "")