topic Re: StringIndexOutOfBoundsException: String index out of range: in Talend Studio

StringIndexOutOfBoundsException: String index out of range:

Anonymous — Fri, 13 Jul 2018 21:52:48 GMT

Hi,

Please advise me below. Thank you!

I have below "out of range" problem after I run my job by using updated source

Previously I can run smoothly with below syntax

row1.BOL.substring(0,4).equals("EXDO")||row1.BOL.substring(0,4).equals("DMCQ")?"LCLshipment":"Invalid"

Can not find any clue for that.

Data sample for BOL is

BOL
CMDUCAD0323962MB
EGLV235800292095
206739726
206756945
206783071
206671602
206535382
EGLV149800286242
HLCUHAM180317960
EXDO6810670633

Re: StringIndexOutOfBoundsException: String index out of range:

Anonymous — Mon, 16 Jul 2018 04:50:34 GMT

Hello,

Would you mind posting your job setting screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

Re: StringIndexOutOfBoundsException: String index out of range:

manodwhb — Mon, 16 Jul 2018 06:53:04 GMT

@szhou1,use the below way and let me know?

StringHandling.LEN(row1.BOL)>4 &&(row1.BOL.substring(0,4).equals("EXDO")||row1.BOL.substring(0,4).equals("DMCQ"))?"LCLshipment":"Invalid"

Re: StringIndexOutOfBoundsException: String index out of range:

Anonymous — Mon, 16 Jul 2018 15:03:56 GMT

Hi,

Thank you for your advise. I run smoothly with syntax - I am wondering why it works when I add "StringHandling.LEN(row1.BOL)>4"?

I have another question - I also have another syntax to filter if BOL# ends with letter such as "X,Y,Z,B". previously everything is good but for now it shows out of range error either. I tried to add "StringHandling.LEN(row1.BOL)>4" but NOT work.

Can you please advise me about this?

My current syntax is

row1.BOL.substring(row1.BOL.length()-1, row1.BOL.length()).equals("X")||row1.BOL.substring(row1.BOL.length()-1,row1.BOL.length()).equals("Y")||row1.BOL.substring(row1.BOL.length()-1,row1.BOL.length()).equals("Z")||row1.BOL.substring(row1.BOL.length()-1,row1.BOL.length()).equals("B")?"Dynamic":"Invalid"

Re: StringIndexOutOfBoundsException: String index out of range:

manodwhb — Tue, 17 Jul 2018 05:34:50 GMT

@szhou1,since your data length is less than 4 in row1.BOL for some of the values so that's way you were getting out of range" problem.

try the below one and let me know.

row1.BOL.length()>1 &&(row1.BOL.substring(row1.BOL.length()-1, row1.BOL.length()).equals("X")
||row1.BOL.substring(row1.BOL.length()-1,row1.BOL.length()).equals("Y")
||row1.BOL.substring(row1.BOL.length()-1,row1.BOL.length()).equals("Z")
||row1.BOL.substring(row1.BOL.length()-1,row1.BOL.length()).equals("B"))?"Dynamic":"Invalid"

Re: StringIndexOutOfBoundsException: String index out of range:

manodwhb — Tue, 17 Jul 2018 05:35:34 GMT

@szhou1,since your data length is less than 4 in row1.BOL for some of the values so that's way you were getting out of range" problem.

try the below one and let me know.

Re: StringIndexOutOfBoundsException: String index out of range:

Anonymous — Wed, 02 Oct 2019 08:03:23 GMT

StringIndexOutOfBoundsException error is realted to Java substring and it means you are attempting to access a character which would come after the end of the string. If a String is only 4 characters long, attempting to get the substring from index 0 - 8, will throw this exception. substring(beginIndex, endInded) throws IndexOutOfBoundsException if the beginIndex is negative, or endIndex is larger than the length of this String object, or beginIndex is larger than endIndex.