topic Re: [resolved] Always two decimals in my int .## in Talend Studio

[resolved] Always two decimals in my int .##

jensej — Fri, 03 Jul 2015 09:13:06 GMT

Hi there
I have a column (Int) with prices in my db that looks like this
2290
500
1300
I need too make them
22.90
5.00
13.00
In tmap i just put the preis/100 as a double but then i get
22.9
5.0
13.0

How can i make it like i want, i dont need to round or anything just put a . two steps to the left from the last number.

Re: [resolved] Always two decimals in my int .##

Anonymous — Fri, 03 Jul 2015 09:36:46 GMT

I assume you are outputting these numbers as a string. If you are supplying them as numbers, the format is of little consequence apart from to humans. So this solution is intended for converting the numbers before output as String.
You can either create a routine wrapper for this (preferable) or use it as I demonstrate it below....

(new java.text.DecimalFormat("0.00")).format((row1.intColumn/100))

What I am doing is setting a format of a number with 2 decimal places ("0.00") using the DecimalFormat class. This can go into a tMap column expression or into a routine.

Re: [resolved] Always two decimals in my int .##

jensej — Tue, 07 Jul 2015 12:40:34 GMT

rhall_2.0 wrote:
I assume you are outputting these numbers as a string. If you are supplying them as numbers, the format is of little consequence apart from to humans. So this solution is intended for converting the numbers before output as String.
You can either create a routine wrapper for this (preferable) or use it as I demonstrate it below....
(new java.text.DecimalFormat("0.00")).format((row1.intColumn/100))
What I am doing is setting a format of a number with 2 decimal places ("0.00") using the DecimalFormat class. This can go into a tMap column expression or into a routine.

Format looks good now but values like 2854 changes to 28.00 and 3972 to 39.00. I need to have them 28.54 and 39.72

Re: [resolved] Always two decimals in my int .##

Anonymous — Tue, 07 Jul 2015 13:02:35 GMT

Ah OK. Try this.....

(new java.text.DecimalFormat("0.00")).format(((double)row1.intColumn/100))

Re: [resolved] Always two decimals in my int .##

jensej — Tue, 07 Jul 2015 15:26:49 GMT

rhall_2.0 wrote:
Ah OK. Try this.....
(new java.text.DecimalFormat("0.00")).format(((double)row1.intColumn/100))

Perfect, thanks mate!