https://community.qlik.com/t5/Talend-Studio/String-to-Double/m-p/2303189#M75100 <P>Hello,&nbsp;</P> <P>I have some input data in XLS which contains values for example (1176,77)</P> <P>i want to transform this data in Double or Float to be used some Mathematic Calculations in theses values</P> <P>&nbsp;</P> <P>I tryied Double.ParseDouble, but i got error</P> <P>Exception in component tMap_1 (Study)<BR />java.lang.NumberFormatException: For input string: "1176,77"</P> <P>at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)<BR />at sun.misc.FloatingDecimal.parseDouble(Unknown Source)</P> Tue, 25 Jun 2019 18:51:37 GMT Anonymous 2019-06-25T18:51:37Z https://community.qlik.com/t5/Talend-Studio/String-to-Double/m-p/2303189#M75100 <P>Hello,&nbsp;</P> <P>I have some input data in XLS which contains values for example (1176,77)</P> <P>i want to transform this data in Double or Float to be used some Mathematic Calculations in theses values</P> <P>&nbsp;</P> <P>I tryied Double.ParseDouble, but i got error</P> <P>Exception in component tMap_1 (Study)<BR />java.lang.NumberFormatException: For input string: "1176,77"</P> <P>at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)<BR />at sun.misc.FloatingDecimal.parseDouble(Unknown Source)</P> Tue, 25 Jun 2019 18:51:37 GMT https://community.qlik.com/t5/Talend-Studio/String-to-Double/m-p/2303189#M75100 Anonymous 2019-06-25T18:51:37Z https://community.qlik.com/t5/Talend-Studio/String-to-Double/m-p/2303190#M75101 Replace comma by point before to cast from string to double Tue, 25 Jun 2019 19:03:39 GMT https://community.qlik.com/t5/Talend-Studio/String-to-Double/m-p/2303190#M75101 TRF 2019-06-25T19:03:39Z https://community.qlik.com/t5/Talend-Studio/String-to-Double/m-p/2303191#M75102 Pefect, i didnt notice this stuff<BR /><BR />Thanks Tue, 25 Jun 2019 19:10:29 GMT https://community.qlik.com/t5/Talend-Studio/String-to-Double/m-p/2303191#M75102 Anonymous 2019-06-25T19:10:29Z