Extracting text from any part of the row in a new column

[sriniprad08]

Hi Team,

Hope you are well. I need help. 

Please find attached the input and output. The workflow should search for the required key words and put in a new column. Irrespective of the location of the word in the sentence.

Thanks again

Sri

[Qiu · Accepted solution]

@sriniprad08 
look like a typical application of Find and Replace tool. 😁

[sriniprad08]

Hi @Qiu ,

Thank you so much. Really appreciate your time.

I will run through on my data and get back to you incase of further help,

Cheers,

Sri

[sparksun · Accepted solution]

Regex tool can make it as well