topic [resolved] Convert a String to Long in Talend Studio https://community.qlik.com/t5/Talend-Studio/resolved-Convert-a-String-to-Long/m-p/2335146#M103740 I setting a variable as <BR />Long.parseLong(row1.precio.trim()) <BR />but released the following exception... <BR />Exception in component tMap_1 <BR />java.lang.NumberFormatException: For input string: "100.00" <BR /> at java.lang.NumberFormatException.forInputString(Unknown Source) <BR /> at java.lang.Long.parseLong(Unknown Source) <BR /> at java.lang.Long.parseLong(Unknown Source) <BR /> at tabd.importprices_0_1.ImportPrices.tFileInputExcel_1Process(ImportPrices.java:934) <BR /> at tabd.importprices_0_1.ImportPrices.runJobInTOS(ImportPrices.java:1286) <BR /> at tabd.importprices_0_1.ImportPrices.main(ImportPrices.java:1195) <BR />OS: Win XP SP3 <BR />TOS: 3.1.3 Sat, 16 Nov 2024 13:29:05 GMT Anonymous 2024-11-16T13:29:05Z [resolved] Convert a String to Long https://community.qlik.com/t5/Talend-Studio/resolved-Convert-a-String-to-Long/m-p/2335146#M103740 I setting a variable as <BR />Long.parseLong(row1.precio.trim()) <BR />but released the following exception... <BR />Exception in component tMap_1 <BR />java.lang.NumberFormatException: For input string: "100.00" <BR /> at java.lang.NumberFormatException.forInputString(Unknown Source) <BR /> at java.lang.Long.parseLong(Unknown Source) <BR /> at java.lang.Long.parseLong(Unknown Source) <BR /> at tabd.importprices_0_1.ImportPrices.tFileInputExcel_1Process(ImportPrices.java:934) <BR /> at tabd.importprices_0_1.ImportPrices.runJobInTOS(ImportPrices.java:1286) <BR /> at tabd.importprices_0_1.ImportPrices.main(ImportPrices.java:1195) <BR />OS: Win XP SP3 <BR />TOS: 3.1.3 Sat, 16 Nov 2024 13:29:05 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Convert-a-String-to-Long/m-p/2335146#M103740 Anonymous 2024-11-16T13:29:05Z Re: [resolved] Convert a String to Long https://community.qlik.com/t5/Talend-Studio/resolved-Convert-a-String-to-Long/m-p/2335147#M103741 Hello <BR />You should substring the string if there is a period? for example: <BR />row1.precio.contains(".")?row1.precio.substring(0,row1.precio.indexOf("."):row1.precio <BR />Best regards <BR />Shong Wed, 31 Mar 2010 02:53:30 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Convert-a-String-to-Long/m-p/2335147#M103741 Anonymous 2010-03-31T02:53:30Z Re: [resolved] Convert a String to Long https://community.qlik.com/t5/Talend-Studio/resolved-Convert-a-String-to-Long/m-p/2335148#M103742 It´s working.<BR />Thank you Wed, 31 Mar 2010 18:26:13 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Convert-a-String-to-Long/m-p/2335148#M103742 Anonymous 2010-03-31T18:26:13Z