Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] String index out of range

#1 2012-05-29 12:13:19

sivaa.m
New member
Registered: 2012-05-21
Posts: 7

[resolved] String index out of range

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


Uploaded Images

Last edited by sivaa.m (2012-05-29 12:16:38)

Offline

#2 2012-05-29 12:40:48

avdbrink
Member
Company: Conspect Consulting & ICT
Registered: 2010-11-08
Posts: 360
Website

Re: [resolved] String index out of range

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:

Code:

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

Hope this helps.

Regards,
Arno

Offline

#3 2012-05-29 12:55:13

sivaa.m
New member
Registered: 2012-05-21
Posts: 7

Re: [resolved] String index out of range

Hi,

Thanks for the reply. The issue got resolved.

Can you explain me the syntax which you have given.

Thanks
Siva

Offline

#4 2012-05-29 14:21:15

avdbrink
Member
Company: Conspect Consulting & ICT
Registered: 2010-11-08
Posts: 360
Website

Re: [resolved] String index out of range

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

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] String index out of range

Board footer

Powered by FluxBB