Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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]+", "")