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!
