Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

How to restrict to just the word I want in a contains filter within a report.

Avatar

Level 6

I am looking to run a filter that pulls any project that's name contains the word IVA. The problem is there are words with the letters iva within them. Is there a way to dictate that I only want the ones where IVA are their own word? I tried typing a space before and after but that didn't work.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee

I just checked with support and they said you're on the right track... but to think about adding a filter for does not contain through text mode. Here's a simple example for you to experiment with:

AND:1:name=123

AND:1:name_Mod=cinotcontains

AND:2:name=Gate

AND:2:name_Mod=cinotcontains

name=test

name_Mod=cicontains

View solution in original post

4 Replies

Avatar

Level 6

If there isn't a way to tell it to only use when just IVA is there a way to add a list of words not to include?

Avatar

Correct answer by
Employee

I just checked with support and they said you're on the right track... but to think about adding a filter for does not contain through text mode. Here's a simple example for you to experiment with:

AND:1:name=123

AND:1:name_Mod=cinotcontains

AND:2:name=Gate

AND:2:name_Mod=cinotcontains

name=test

name_Mod=cicontains

Avatar

Level 6

Yay it worked! Have I mentioned how much I Love this community??? Thank You So Much.

Avatar

Employee

Wonderful! I'm so glad. I'm so glad you're part of this community!