Urgent:Regex a code from the column

[Bowiebobobo]

I'd like to only regex one or more codes from the Input column according the code list.

For example:

Input (free format)

Input

25,own6,loc8,Scr1,C2cpdb

99.5,Code:IDC2-Admin,,$re:$Code2,SFA33-REG,

98，Code:FAC9W-Admin,C2cptrnu-Reg,Acomp24

_x000d_49.75,Code:BOW1-Reg,SCR9-Reg,,$re:$Code2:CRG-Admin,SupD1,

75,Code:ASP04-Reg,$Code2:LOCR4

71.5,Code:COP1-Admin,ACR1-P&P,ASP04 REG,$re:$Code2:CRP-Admin,SupD1,

99.5,Code:ASP05-Admin,,$re:$Code2:FAD3W,CRS-Admin,SFA10,SupD1,BOA3-FDD

100，C2cpfgg

71.75,Code:SO1962a-Reg,KCS7-P&P,,$re:$Code2:CRO-Admin,_x000d_

99,Code:EDG-N1

99,Code:,,

Output:

Output1	Output2	Output3	Output4	Output 5
OWN6	LOC8	SCR1	C2CPDB
IDC2	SFA33
FAC92	C2CPTRNU	ACOMP24
BOW1	SCR9	CRG	SUPD1
ASP04	LOCR4
COP1	ACR1	ASP04	CRP	SupD1
ASP05	FAD3W	SFA10	SupD1	BOA3-FDD
C2CPFGG
SO1962A	KCS7	CRO
EDG-N1

Code List:

Code

OWN6

IDC2

FAC92

BOW1

ASP04

COP1

ASP05

C2CPFGG

SO1962A

EDG-N1

LOC8

SFA33

C2CPTRNU

SCR9

LOCR4

ACR1

FAD3W

KCS7

SCR1

ACOMP24

CRG

SFA10

C2CPDB

SUPD1

BOA3-FDD

CRO

CRP

[Qiu]

@Bowiebobobo 
Hope this is what you need.

[Bowiebobobo]

Thanks for prompt reply~ amazing solution and very helpful for us.

[Qiu]

@Bowiebobobo 
Thank you for the confirmation and would appreciate if you could mark it as accept if it helps. 😁