https://community.qlik.com/t5/Talend-Studio/java-lang-StringIndexOutOfBoundsException-String-index-out-of/m-p/2306219#M77790 Your index is out of range probably because it didn't find an occurrence of XLS and you tried to do a left and right function on it. Fri, 26 Apr 2013 14:04:44 GMT janhess 2013-04-26T14:04:44Z https://community.qlik.com/t5/Talend-Studio/java-lang-StringIndexOutOfBoundsException-String-index-out-of/m-p/2306218#M77789 Hi, <BR />I am getting java.lang.StringIndexOutOfBoundsException: String index out of range: -2 while loading the talend job; <BR />Exception in component tMap_1 <BR />java.lang.StringIndexOutOfBoundsException: String index out of range: -2 <BR /> at java.lang.String.substring(String.java:1937) <BR /> at routines.StringHandling.LEFT(StringHandling.java:210) <BR />In my tmap_1 <BR />StringHandling.RIGHT(StringHandling.LEFT(context.filepath,StringHandling.INDEX(context.filepath,"XLS")-1),2) <BR />Please help me <BR />Chin Fri, 26 Apr 2013 13:07:10 GMT https://community.qlik.com/t5/Talend-Studio/java-lang-StringIndexOutOfBoundsException-String-index-out-of/m-p/2306218#M77789 Anonymous 2013-04-26T13:07:10Z https://community.qlik.com/t5/Talend-Studio/java-lang-StringIndexOutOfBoundsException-String-index-out-of/m-p/2306219#M77790 Your index is out of range probably because it didn't find an occurrence of XLS and you tried to do a left and right function on it. Fri, 26 Apr 2013 14:04:44 GMT https://community.qlik.com/t5/Talend-Studio/java-lang-StringIndexOutOfBoundsException-String-index-out-of/m-p/2306219#M77790 janhess 2013-04-26T14:04:44Z