topic Re: Need to get String less than 60 length in Talend Studio

Need to get String less than 60 length

amitdadri — Thu, 20 Sep 2018 10:46:30 GMT

Hi all previously I was using routines.utils.getNotes(SFOpportunities.Notes__c) to extract the values from field named Notes , length 32768 into next field with a lenght of 60 both string. and I am getting an error

Exception in component tMap_4
java.lang.StringIndexOutOfBoundsException: String index out of range: 60
at java.lang.String.substring(Unknown Source)
at routines.utils.getNotes(utils.java:571)

can anyone see this

Re: Need to get String less than 60 length

vapukov — Thu, 20 Sep 2018 10:51:21 GMT

it means column shorter than 60, for example " "

check in source database MIN(lenght()) for column

Re: Need to get String less than 60 length

amitdadri — Thu, 20 Sep 2018 11:23:17 GMT

Hi @vapukov thanks for reply, the source also has the field length as 32768 only,

Re: Need to get String less than 60 length

vapukov — Thu, 20 Sep 2018 11:27:28 GMT

do You check this by query? (not by definition)
You need any 1 rows shorter to have error

Re: Need to get String less than 60 length

amitdadri — Thu, 20 Sep 2018 11:39:48 GMT

Hi @vapukov the source is Salesforce and I dont know much to query in that, I just work in Talend, can you please tell me about that

Re: Need to get String less than 60 length

vapukov — Thu, 20 Sep 2018 11:45:18 GMT

in saleforce they have SOQL - https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql.htm

in talend You can check real lengths, something like:

row1.col==null?
null
:StringHandling.LEN(row1.col)<60?
row1.col
:StringHandling.LEFT(row1.col, 60)

Re: Need to get String less than 60 length

amitdadri — Thu, 20 Sep 2018 12:22:39 GMT

I do understand your solution, meanwhile I used this

StringHandling.LEN(coLname)>58?colname.substring(0,58):colname

Is this fine?

The min lenght is 0 it is nullable, so I don't understand is then why do I get the error

@vapukov

Re: Need to get String less than 60 length

vapukov — Thu, 20 Sep 2018 12:37:07 GMT

it similar, I just add check for NULL