topic Re: [resolved] Suppress Exponent in a double format in Talend Studio

[resolved] Suppress Exponent in a double format

_AnonymousUser — Sat, 16 Nov 2024 13:50:57 GMT

Hi everyone,
I need to obtain a double which has no exponent in an csv file. The file is from a tfileOutputdelimited.
In my files I got these things : 3.53435E12 and I need 353435000000.
And I also need to keep the decimal if there are any.
I tried a few things on the tmap but I could'nt find any solutions.
Someone has any idea ?

Thanks,

Re: [resolved] Suppress Exponent in a double format

Anonymous — Tue, 04 Aug 2009 03:21:59 GMT

Hello
I tested it on tJava:

	double d = 3.53435E12;
			java.text.DecimalFormat df = new java.text.DecimalFormat("#.#");
                        String s=df.format(d);
			System.out.println("d   =   " + s);

result:

tarting job forum7601 at 10:13 04/08/2009.
d   =   3534350000000
Job forum7601 ended at 10:13 04/08/2009.

Best regards

shong

Re: [resolved] Suppress Exponent in a double format

_AnonymousUser — Tue, 04 Aug 2009 08:29:35 GMT

thank you for the answer

Re: [resolved] Suppress Exponent in a double format

tYrannoSaurusRex_1 — Wed, 25 Mar 2015 09:32:44 GMT

And how to achieve it in tMap?

Re: [resolved] Suppress Exponent in a double format

Anonymous — Thu, 26 Mar 2015 01:06:09 GMT

And how to achieve it in tMap?

Create a method in a routine to do it, the method requires an input parameter, you just need to call the routine and pass the incoming data as input parameter on tMap.