How to get a part of data from text for all rows?

[ToxicBuoy]

Hi All,

I have a sample data like the below(Values), I need to create a new column(Output) with values if 'Pradan' is available then fetch is corresponding value:

Values:

1. ABC Pradan

2. DE Pradan

3. FGH Covered,IJ Pradan

4. KLM Pradan,NOP Pradan

5. QR Dummy,STU Covered

Output:

1. ABC is present

2. DE is present

3. IJ is present

4. KLM and NOP is present

5. [null]

[Emil_Kos · Accepted solution]

Hi @ToxicBuoy,

I have prepared a workflow for you:

The output:

[ToxicBuoy]

Thanks @Emil_Kos for your reply. Much appreciated.