Parsing Numbers and Characters from String

[DHB]

Hi all,

Hope you're keeping well.  I wondered if anyone could help me to parse some codes from a string. 

The codes have these characteristics;

• Always start with 4 digits (no more than 4)
• Sometimes have letters (between 1 and 4) at the end of those digits
• The start of the code is always the first instance of a digit in the string
• Prior to the code there is always a letter code which sometimes contains a space or '&'.  These vary in length.

Here's an example of the data (STRING) and what I'd like to achieve (TARGET)

STRING	TARGET
AGRONOMY 3012RW Innovation in Agronomy III	3012RW
ANAT SC 1102 Human Biology IA	1102
ANAT SC 1102UAC Human Biology IA	1102UAC
ANAT SC 1103 Human Biology IB	1103
C&ENVENG 1008 Eng Plan & Design I	1008
C&ENVENG 1008UAC Eng Plan & Design I	1008UAC
C&ENVENG 1009 Civil&Env Eng 1	1009
BIOTECH 7003 Advanced Research Techniques	7003
BIOTECH 7004 Molecular Micro & Vaccines	7004

Any help would be greatly appreciated.

Best,

DHB

[atcodedog05 · Accepted solution]

Hi @DHB ,

Sure the regex and workflow to catch the code.

Hope this helps : )

Cheers and Happy Analyzing 

[DHB]

That's perfect.  Thank you so much 

[atcodedog05]

Hi @DHB ,

Glad to hear that helped.

If that helped can you please mark my post as "Accept solution"

Thank you : )