Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

[resolved] Suppress Exponent in a double format

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,
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

4 Replies
Anonymous
Not applicable

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
_AnonymousUser
Specialist III
Specialist III
Author

thank you for the answer
tYrannoSaurusRex_1
Contributor III
Contributor III

And how to achieve it in tMap?
Anonymous
Not applicable

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.