How to have better substring filter

Hi Everyone,

I try to filter a list based on job title such as IT. It is very annoying by pulling Credit.. any word containing it but I actually look for it director, it manager only.

Please kindly share your thought to make it easier. Thank you very much!!

Regex

Accepted answers

lmorrell

Hi @marlline141

Workflow is attached

How to have better substring filter.png

I can see lots of great solutions in this thread, but I've had a similar problem in the past so I'll adapt that solution here. It might be a little overkill, but perhaps a RegEx statement in a Filter Tool checking that there are no letters linking to 'IT' can solve the issue?

regex_match([Field1], '[A-Z]+it') = 0 AND regex_match([Field1], 'it[A-Z]+') = 0

This will exclude 'Credit', account for either uppercase or lowercase instances of 'IT', and works for the provided examples.

Hope this helps!

How to have better substring filter.yxmd

All comments

DiganP

@marlline141 You want to use this function: [Field1] in ('IT')

Attached is the workflow.

Before:

After:

Does this help?

filter.yxmd

marlline141

@DiganP

Thanks for helping out. But it does not work. When I try lowercase([Job Title]) IN ('it'), IT Manager will not be picked up. Could you explain why?

echuong1

Will the job titles with IT always be multiple words? If so, you can use a filter tool and search for instances of " IT" and "IT ". See attached for an example workflow.

New Workflow3.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335