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.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.