Talend community forum / substring function

skatpally · 2012-04-09 19:08:37

Hi Guys,
I have a question regarding substring function. I am trying to extract first 3 characters from column.

Following is the function i am using. StringHandling.substr(DSLink3.col1,1,3). I am getting error.

Thanks for help

vgalopin · 2012-04-10 16:54:13

Hi skatpally,

You can do the following:
DSLink3.col1.substring(0,3).

In Java, the index of the first character is 0, not 1.

Announcement

Unanswered posts

#1 2012-04-09 19:08:37

substring function

#2 2012-04-10 16:54:13

Re: substring function

Board footer