topic Re: Converting a string to BigDecimal in Talend Studio

Converting a string to BigDecimal

Anonymous — Sat, 16 Nov 2024 03:25:03 GMT

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.

Re: Converting a string to BigDecimal

Anonymous — Wed, 29 Jan 2020 20:36:55 GMT

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

Re: Converting a string to BigDecimal

Anonymous — Mon, 03 Feb 2020 14:31:18 GMT

Hi,

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