I have the following:
I'm using StringHandling.LEFT(row1.SOURCE_SITE_ID,4) this extracts the first 4 elements, but what I need is to select everything after the '_' so the result would be:
I'm a beginner, can anyone help me with this string manipulation?
Could you please try this method StringHandling.LEFT(row1.SOURCE_SITE_ID,5) to see if it works?
StringHandling.LEFT(row1.SOURCE_SITE_ID,5) removes the first 5 characters from the left, however, in my example the number of characters to be removed varies, I need to remove either everything before and including the _ to the left or right. I'm trying to get into Regex syntax to see if that has what I need.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Find out about Talend's 2019 Summer release
Talend continues to revolutionize how businesses leverage speed and manage scale
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend