topic Re: Convert from BigDecimal to String in Talend Studio

Convert from BigDecimal to String

mgchong — Sun, 19 Jan 2014 02:30:29 GMT

Hi guys,
My goal is to convert from source value 0.0000 (4 precision) to 0.00 (2 precision) in String format.
I noticed there is an issue when converting from BigDecimal to String. For example, my source file with value 0.0000 (I am setting it as 2 precision in BigDecimal format). Next, I am using tmap to convert it into string. (refer to my attached screen shot).
The problem is that after converting to String, the value change back to 4 precision 0.0000 instead of 0.00

Re: Convert from BigDecimal to String

mgchong — Sun, 19 Jan 2014 02:34:37 GMT

Screenshot - http://screencast.com/t/lSsndd6VC

Re: Convert from BigDecimal to String

Anonymous — Sun, 19 Jan 2014 21:02:32 GMT

You could do this:

java.text.NumberFormat.getInstance(Locale.ENGLISH).format(Math.round(row1.my_big_decimal_value.doubleValue() * 100d) / 100d)

The precision in your input flow will not used to read / create the BigDecimal value. Length and precision are only be used if you create a table or if you use the build-in to string conversion.

Re: Convert from BigDecimal to String

mgchong — Mon, 20 Jan 2014 13:13:20 GMT

Hi Jlolling,
Thanks for the information.