Talend community forum / Format of decimal number

Jose Vaquero · 2009-06-08 15:09:33

Tags: [Format of decimal number, PostgreSQL]

Hello:
I need convert some numbers, from a BD in format double, to a XML file. I need than the number has two decimals. How can I do, when the original number is 0? I only get the result 0.0, but I need 0.00
Another example of the same problem: when I pass the number 8.36 to SML, I need six decimals, and so I need 8.360000

Greetings Thanks
Jose

bcourtine · 2009-06-08 19:55:41

With java jobs, you can use the java class "DecimalFormat" in a tJavaRow :

Code:

DecimalFormat myFormat = new DecimalFormat("0.00");
rowX.myFormattedDate = myFormat.format(rowX.myNumericRow);

Jose F Vaquero · 2009-06-12 10:21:08

Thank you for the answer, but...
I need put this code in the "expression Builder", in a component tMap. In this place, it don't work,it say "syntax error". I think than I could use a direct function to became the result. Some idea??
Greetings

shong · 2009-06-12 10:40:03

Hello

in a component tMap. In this place, it don't work,it say "syntax error"

Write these code in a routine, then call the routine on tMap.

Best regards

shong

Jose Vaquero · 2009-06-17 13:49:49

Thank you for the answer.
If I wat to use a conditional sentence, can I used some function in a tMap, or I must add this conditional sentence in a routine too?

I think, for example:
if field1 == Y
"ELECTRONIC"
else
POSTAL

Greetings

emenuet · 2009-06-17 14:45:20

hello,
you can use this in a tMap expression field :

1) Y, POSTAL and field1 are var : field1 == Y ? "ELECTRONIC" : POSTAL
2) Y, POSTAL are String : "Y".equals(field1) ? "ELECTRONIC" : "POSTAL"

Announcement

Unanswered posts

#1 2009-06-08 15:09:33

Format of decimal number

#2 2009-06-08 19:55:41

Re: Format of decimal number

Code:

#3 2009-06-12 10:21:08

Re: Format of decimal number

#4 2009-06-12 10:40:03

Re: Format of decimal number

#5 2009-06-17 13:49:49

Re: Format of decimal number

#6 2009-06-17 14:45:20

Re: Format of decimal number

Board footer