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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-01-24 07:14 AM

[resolved] How do i convert scientific notation to decimal notation?

My excel file has input string in Scientific notation i want to convert it to decimal notation. 
scientific notation excel:2.00E+11 (actual value:200002000000)
I need output as 0 (Seperate first 7 char | 6 char char) second part i need to insert in my db.
Talend shows me error For input string: "2.00625E+11", when i am trying t_convert STRING to LONG conversion. For other scientific notations it works but if last 6 digits are 0 it fails to convert. 
Can somebody help getting me last 6 digit of the decimal notation of scientific notation passed in excel file?
or any other short way for doing this?
Labels (2)
Labels
422 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2015-01-25 11:01 PM
Author

Hi,
Please take a look at a related forum: https://community.talend.com/t5/Design-and-Development/scientific-notation-being-written-out/td-p/78....
Best regards
Sabrina
422 Views
0 Likes
Anonymous
Not applicable
‎2015-01-27 04:12 AM
Author

i love talend , wonderful tool wonderful community. simply the best.
422 Views
0 Likes
Anonymous
Not applicable
‎2015-01-27 04:40 AM
Author

Hi,
Glad you could solve the issue. Feel free to post your issue on Talend Forum.

Best regards
Sabrina
422 Views
0 Likes