Find words from fixed list in a string and return as output

[EstherT]

Hi all,

I've been trying to find certain codes/characters (coming from a second file) in a string and returning those as output in a separate column.

For example

Input 1

ID	Field 1
12345	203,311,A00,A003
67890	K00,365,230,A00,A002,210

Input 2 (list)

code

A00

A001

A002

A003

B00

E002

K00

Desired output:

ID	Field 1	Output
12345	203,311,A00,A003	A00,A003
67890	K00,365,230,A00,A002,210	K00,A00,A002

Any suggestions on which tools I should use?

Many thanks!

[FinnCharlton]

Hi @EstherT , this workflow should do the job. Hope it helps!

[binuacs]

@EstherT One way of doing this

[binuacs]

@FinnCharlton Are you facing any issues uploading the images of your workflow? I am getting some weird error

[FinnCharlton]

@binuacs yeah I am, never seen it before. Glad it's not just me

[l_waldram]

I found a previous thread with somebody with the same query, which was solved, linked here: 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Find-multiple-values-in-string... 

[nagakavyasri]