REGEX SPLIT

Hi,

I want to use RegEx split to extract the following “1234567BR” out of titles that vary in their formatting of text and numbers but “1234567BR” will always be the same - 7 numbers and BR at the end.

Could someone please recommend appropriate regex for this?

Thank you

Assuming that the pattern appears only once, you can try the following regex:

.*(\d{7}BR).*
1 Like

Here you’ve got three examples how to archive it. All give the same result but have some implications. The first, RegEx Split, requires an exact match or its result for non matching strings will be missing (more failure resistant).

The second and last approach are more failure prone because they will give back also non-matching input values.

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.