Reg Ex to extract specific sequence of digits/letters

[arianner]

Hi, 

I have a chunk of data in a column and I need to parse out a specific sequence which is a combo of 2, sometimes 3 letters, followed by 2 numbers and then 2023

Ex:

BRB092023

GL042023

using this "\b(u\u\d\d\d2023)\b" for the regular expression gets me to "null" and the only way I can extract any data is I have only "(2023)" in the expression box. 

How can I pull out the entire segment of the examples listed above? (I have a feeling I'll need 2 RegEx tools, 1 for the 3 letter start and 1 for the 2 letter start)

thank you!

[Watermark]

Do you have an actual set of data?   Maybe 20-25 records?   You seem to have provided the extract? Like to know what other data may surround it?

[Raj]

Share sample data

[Yoshiro_Fujimori · Accepted solution]

Hi @arianner ,

Is this what you want to do?

Input

Output

RegEx configuration

[arianner]

Yes! thank you so much!