https://community.qlik.com/t5/Talend-Studio/converting-String-to-Integer-error-tmap/m-p/2211873#M9721 Hi, <BR />I am stuck with this error and unable to figure out what's wrong the expression, I am converting a string value to integer based on the condition, below is the expression I have added in the tMap <BR />(StringHandling.TRIM(Source.SR_Current_SA_Number.toString()) == "Not Available")?Integer.parseInt("0".toString()):Integer.parseInt(StringHandling.TRIM(Source.SR_Current_SA_Number.toString())) <BR /> <BR />Error exception : <BR />Exception in component tMap_1 <BR />java.lang.NumberFormatException: For input string: "Not Available" <BR /> at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48) <BR /> at java.lang.Integer.parseInt(Integer.java:449) <BR /> at java.lang.Integer.valueOf(Integer.java:554) <BR /> at nexus.import_closed_cases_0_1.Import_Closed_Cases.tOracleInput_1Process(Import_Closed_Cases.java:2379) <BR /> at nexus.import_closed_cases_0_1.Import_Closed_Cases.runJobInTOS(Import_Closed_Cases.java:3076) <BR /> at nexus.import_closed_cases_0_1.Import_Closed_Cases.main(Import_Closed_Cases.java:2947) <BR />------- <BR />Any help wil be much appreciated. <BR />Thanks, <BR />Naran Sat, 16 Nov 2024 12:59:10 GMT Anonymous 2024-11-16T12:59:10Z https://community.qlik.com/t5/Talend-Studio/converting-String-to-Integer-error-tmap/m-p/2211873#M9721 Hi, <BR />I am stuck with this error and unable to figure out what's wrong the expression, I am converting a string value to integer based on the condition, below is the expression I have added in the tMap <BR />(StringHandling.TRIM(Source.SR_Current_SA_Number.toString()) == "Not Available")?Integer.parseInt("0".toString()):Integer.parseInt(StringHandling.TRIM(Source.SR_Current_SA_Number.toString())) <BR /> <BR />Error exception : <BR />Exception in component tMap_1 <BR />java.lang.NumberFormatException: For input string: "Not Available" <BR /> at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48) <BR /> at java.lang.Integer.parseInt(Integer.java:449) <BR /> at java.lang.Integer.valueOf(Integer.java:554) <BR /> at nexus.import_closed_cases_0_1.Import_Closed_Cases.tOracleInput_1Process(Import_Closed_Cases.java:2379) <BR /> at nexus.import_closed_cases_0_1.Import_Closed_Cases.runJobInTOS(Import_Closed_Cases.java:3076) <BR /> at nexus.import_closed_cases_0_1.Import_Closed_Cases.main(Import_Closed_Cases.java:2947) <BR />------- <BR />Any help wil be much appreciated. <BR />Thanks, <BR />Naran Sat, 16 Nov 2024 12:59:10 GMT https://community.qlik.com/t5/Talend-Studio/converting-String-to-Integer-error-tmap/m-p/2211873#M9721 Anonymous 2024-11-16T12:59:10Z https://community.qlik.com/t5/Talend-Studio/converting-String-to-Integer-error-tmap/m-p/2211874#M9722 Hi <BR />In Java, to determine whether two strings are equal should use string1.equals("string2"), try this expression: <BR />(StringHandling.TRIM(Source.SR_Current_SA_Number.toString()) .equals("Not Available"))?Integer.parseInt("0".toString()):Integer.parseInt(StringHandling.TRIM(Source.SR_Current_SA_Number.toString())) <BR />Best regards <BR />Shong Tue, 12 Apr 2011 07:37:48 GMT https://community.qlik.com/t5/Talend-Studio/converting-String-to-Integer-error-tmap/m-p/2211874#M9722 Anonymous 2011-04-12T07:37:48Z