SOLVED

I want to use "Contains" in a smart list but I want the word in the field to not be attached to other words.

Go to solution
Highlighted
Anonymous
Not applicable

I want to use "Contains" in a smart list but I want the word in the field to not be attached to other words.

For example:

Using Company Name Contains: "Mini"

I want to see "John Elway Mini Dealership"

I do not want to see "Dominican University"

Is there a way I can specify that I don't want the value I enter for "Contains" to be a part of a larger word?

I fully understand that this is asking a bit much for a "Non Best Practice" filter, but It could help me alot.

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: I want to use "Contains" in a smart list but I want the word in the field to not be attached to other words.

Hi Mitch,

Have to tried to set contains " Mini " ?

Anyhow, wildcards for filter has been a idea for a long time:

-Greg

View solution in original post

2 REPLIES 2
Highlighted

Re: I want to use "Contains" in a smart list but I want the word in the field to not be attached to other words.

Hi Mitch,

Have to tried to set contains " Mini " ?

Anyhow, wildcards for filter has been a idea for a long time:

-Greg

View solution in original post

Highlighted
Anonymous
Not applicable

Re: I want to use "Contains" in a smart list but I want the word in the field to not be attached to other words.

Thanks Gregoire,

I did actually try that.  It yielded no results.  I have tried several iterations of the concept, but I believe my ask falls squarely in the "Wild Card" area.

Thank you for your response.