topic [resolved] String index out of range in Talend Studio

[resolved] String index out of range

sivaa_m — Tue, 29 May 2012 11:13:19 GMT

Hi,
I am new to talend. I tried to insert the data from source to target. both my source & target are mssql. I used the tmap for mapping between source & target. In the target i need to substring the source values. so i tried the following in the tmap
column_name.substring(start poisitiion,end position).
While execution I am getting the below given error.
Exception in component tMap_1
java.lang.StringIndexOutOfBoundsException: String index out of range: 24
at java.lang.String.substring(Unknown Source)
at edw.psp_dim_0_1.PSP_DIM.tMSSqlInput_1Process(PSP_DIM.java:1015)
at edw.psp_dim_0_1.PSP_DIM.runJobInTOS(PSP_DIM.java:1463)
at edw.psp_dim_0_1.PSP_DIM.main(PSP_DIM.java:1331)
Kindly suggest. Please find the screenshot of the job design & error

Re: [resolved] String index out of range

Anonymous — Tue, 29 May 2012 11:40:48 GMT

Hi,
It seems one of the input strings isn't the supposed length of 24 positions. substring will return with an exception in this case. You could use the following syntax:

column_name.substring(start poisitiion, Math.min(end position, column_name.length()))

Hope this helps.
Regards,
Arno

Re: [resolved] String index out of range

sivaa_m — Tue, 29 May 2012 11:55:13 GMT

Hi,
Thanks for the reply. The issue got resolved.
Can you explain me the syntax which you have given.
Thanks
Siva

Re: [resolved] String index out of range

Anonymous — Tue, 29 May 2012 13:21:15 GMT

Hi,
Sure, what is does is get the characters starting at "start position" (being 0 in your sample I see) and ending at either the last character of the string, or the character at position "end position" (being 24 in your sample). So for a String with length 20 only 20 character will be captured while for a string with length 30, 24 characters will be captured.
Hope this helps.
Regards,
Arno