Talend community forum / Post a reply

Open Data SolutionsData Management solutionswarehouseOpen StudioBusinessExtract Transform LoadETL

You are not logged in.

Announcement

[2013-05-06] Boston Area User Group Meetup
[2013-05-02] NOTICE TO ALL TALENDFORGE USERS: maintenance completed
[2013-04-26] Talend Open Studio's 5.3.0 release is available
[2013-04-12] Ready for testing - Talend Open Studio's 5.3.0RC2 release is available
[2013-04-11] Talend’s corporate pages and groups on social media

Unanswered posts

Problem with SELECT a.name AS a_name, b.name AS b_name input by kacper
SayHelloRoute [...] by gary.liu1119@gmail.com
How to generate jar for use with tBRMS by adaemus
Deployment question regarding [...] by rhuiser
General question about jobservers and runtimes ... by rbadev
Using tBRMS / Drools Guvnor by adaemus
Webservice fails to connect on Oracle when running as [...] by anselmopeixoto

Index
» Product usage, architecture, user scenarios, suggestions & feedback
» substring function

Post a reply

Topic review (newest first)

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.

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

Announcement

Unanswered posts

Post a reply

Topic review (newest first)

Board footer