Filtering Data question

[Jxys422]

Hello

I have a listing of several names that I want to filter to see if they contain a few phrases. 

I want to run a filter that will retrieve all the 'Adobe' and 'Microsoft' from the table below, could someone please provide me an efficient way to do this for several (20+) phrases? 

Thanks in advance!

Name

Adobe Pro v2

Adobe Pro v1

Acrobat

Microsoft Power point

Excel

Microsoft Word

[JosephSerpis · Accepted solution]

Hi @Jxys422 I mocked up a worklfow. Let me know what you think?

[Jxys422]

Thank you so much! this works perfectly!

[ChrisTX]

If you only have 20, the quickest way may be the RegEx tool with Output Method = Match

Regular Expression = .*Adobe.*|.*Microsoft.*|.*OtherText.*

[Jxys422]

Thank you!

[meprice]

Thank you so much for this solution. I was able to use part of it to correct a workflow that I created.  Man, I am finally starting to get it!