Filtering Data question

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

Datasets

Accepted answers

JosephSerpis

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

Filter_141119.yxmd

All comments

JosephSerpis

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

Filter_141119.yxmd

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!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335