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.