[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?