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!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.