topic extracting a string after a character in Data Quality

extracting a string after a character

Anonymous — Sat, 16 Nov 2024 09:14:59 GMT

I have the following:

LI04_1503

AS03_18456

AS03_P45

...

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:

1503

18456

P45

I'm a beginner, can anyone help me with this string manipulation?

Thanks,

Gary

Re: extracting a string after a character

Anonymous — Sat, 30 Sep 2017 10:49:27 GMT

Hello,

Could you please try this method StringHandling.LEFT(row1.SOURCE_SITE_ID,5) to see if it works?

Best regards

Sabrina

Re: extracting a string after a character

Anonymous — Sat, 30 Sep 2017 11:02:57 GMT

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.