How to restrict to just the word I want in a contains filter within a report. | Community
Skip to main content
M
MichaelPe1
Level 5
May 3, 2021
Solved

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

  • May 3, 2021
  • 1 reply
  • 666 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by kynabaker16

    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

    1 reply

    M
    MichaelPe1Author
    Level 5
    May 6, 2021

    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?

    kynabaker16
    Adobe Employee
    kynabaker16Adobe EmployeeAccepted solution
    Adobe Employee
    May 6, 2021

    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

    M
    MichaelPe1Author
    Level 5
    May 7, 2021

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

    Terms & ConditionsAccessibility statement

    Loading footer...