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

Anonymous — Thu, 21 Mar 2019 20:22:56 GMT

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

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

akumar2301 — Thu, 21 Mar 2019 20:29:03 GMT

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

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

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

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