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 IDField 112345203,311,A00,A003 67890K00,365,230,A00,A002,210 Input 2 (list) codeA00A001A002A003 B00E002K00 Desired output: IDField 1Output12345203,311,A00,A003 A00,A00367890K00,365,230,A00,A002,210K00,A00,A002 Any suggestions on which tools I should use? Many thanks!

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

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

Input 2 (list)

code

A00

A001

A002

A003

B00

E002

K00

Desired output:

Any suggestions on which tools I should use?

Many thanks!

Workflow

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

@EstherT One way of doing this

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

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

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

Screenshot 2023-06-23 135053.png