topic Re: [resolved] in tJavaRow rounding float to two decimals and use in String in Talend Studio

[resolved] in tJavaRow rounding float to two decimals and use in String

hvanderborg — Tue, 21 May 2013 11:28:27 GMT

Hi,
Can anybody help me with this: With tJavaRow I'm using code below (simplification of actual use)

output_row.price_ex = (input_row.price/1.21)+" ex vat price"

Challenge: Output has many decimals, but needs to be just two.
FYI: the input is float, the output string
I have read that DecimalFormat might be an approach, unfortunately I am a beginner with Java and Talend so I might need an example what code to use exactly instead of the code above.
Hope someone can help me out

Re: [resolved] in tJavaRow rounding float to two decimals and use in String

Anonymous — Tue, 21 May 2013 12:50:00 GMT

Try this..

output_row.price_ex =  new DecimalFormat("#.##").format((input_row.price/1.21))+"string";

Re: [resolved] in tJavaRow rounding float to two decimals and use in String

hvanderborg — Tue, 21 May 2013 13:27:52 GMT

Try this..

output_row.price_ex =  new DecimalFormat("#.##").format((input_row.price/1.21))+"string";

Thanks, tried but results in this error: "DecimalFormat cannot be resolved to a type". When I google for that it seems I need to add code to import DecimalFormat?

Re: [resolved] in tJavaRow rounding float to two decimals and use in String

alevy — Wed, 22 May 2013 05:44:45 GMT

output_row.price_ex = new java.text.DecimalFormat("#.##").format(input_row.price/1.21)+"string";

Re: [resolved] in tJavaRow rounding float to two decimals and use in String

Anonymous — Wed, 22 May 2013 06:06:52 GMT

Hi havenderborg

yes.. you need to import java.text.DecimalFormat
or you can do it without any import using math of java
try this

      output_row.price_ex =Math.round((input_row.price/1.21)*100)/100f +" ex vat price"

Re: [resolved] in tJavaRow rounding float to two decimals and use in String

hvanderborg — Sun, 09 Jun 2013 11:45:11 GMT

Hi havenderborg

yes.. you need to import java.text.DecimalFormat
or you can do it without any import using math of java
try this
      output_row.price_ex =Math.round((input_row.price/1.21)*100)/100f +" ex vat price"

Just tried the Math.round and that worked, many thanks!
I did notice it didn't have effect if I try that in an expression in tMap (I would still got many decimals), so tJavaRow will solve it for now. (Perhaps I try java.text.DecimalFormat as well later)