topic Re: Format of decimal number in Talend Studio

Format of decimal number

_AnonymousUser — Sat, 16 Nov 2024 13:55:34 GMT

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

Re: Format of decimal number

Anonymous — Mon, 08 Jun 2009 18:55:41 GMT

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

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

Re: Format of decimal number

_AnonymousUser — Fri, 12 Jun 2009 09:21:08 GMT

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

Re: Format of decimal number

Anonymous — Fri, 12 Jun 2009 09:40:03 GMT

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

Re: Format of decimal number

_AnonymousUser — Wed, 17 Jun 2009 12:49:49 GMT

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

Re: Format of decimal number

Anonymous — Wed, 17 Jun 2009 13:45:20 GMT

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"