https://community.qlik.com/t5/Talend-Studio/How-to-convert-Decimal-to-exponential-value/m-p/2220381#M14805 <P>Hi</P><P>&nbsp;</P><P>I am getting "100.0" in the input column and i would like to convert it to "1.00000000000000000E+02". How can i do it in a tmap using conversion function.</P> Sun, 27 Jan 2019 04:45:16 GMT Anonymous 2019-01-27T04:45:16Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-Decimal-to-exponential-value/m-p/2220381#M14805 <P>Hi</P><P>&nbsp;</P><P>I am getting "100.0" in the input column and i would like to convert it to "1.00000000000000000E+02". How can i do it in a tmap using conversion function.</P> Sun, 27 Jan 2019 04:45:16 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-Decimal-to-exponential-value/m-p/2220381#M14805 Anonymous 2019-01-27T04:45:16Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-Decimal-to-exponential-value/m-p/2220382#M14806 <P>Hi,</P><P>you could use format</P><P>&nbsp;</P><PRE>String.format("%.17e",row1.valueDouble)</PRE> Sun, 27 Jan 2019 08:49:21 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-Decimal-to-exponential-value/m-p/2220382#M14806 vapukov 2019-01-27T08:49:21Z