Converting a string to BigDecimal

[Anonymous]

I am trying to convert a string number from one MySQL table to another.

I have used the following on many occasions, however it does not seem to be working in this instance and I am unsure as to why. The string it is converting is "50,000.00"

With that formula in tMap it produces the following error:

When I look at the code on 3031:

So something is just not functioning as I expect. Any help would be great.

[Anonymous · Accepted solution]

If you're trying to get rid of all commas, but retain the '.', you can do something like

row1.Trade_Amount.replaceAll(",","");

you'll also have to reassign the value (i.e. you can't use replace all in-line)

I tested this code with the BigDecimal constructor and it seemed to work

[Anonymous]

Hi,

You have an error in your regex. Use "[^\\d.]"