Skip to main content
A
Anonymous
February 1, 2017
Question

Smart list: <attribute> contains = whole word ?

  • February 1, 2017
  • 2 replies
  • 2141 views

Hello!

I'm trying to build a smart list that captures contacts where a field contains specific words.

I want it to match whole words as opposed to just the characters.

an example would be: contains = mod (as a whole word)

so i wouldn't want it to return entries such as 'module'

More specifically, i'm setting up the Company Web Activity report.

i have a list of let's say our top 100 strategic accounts, and I want to monitor anonymous web activity.

So I need to set up a smart list that looks at the 'inferred company'

Lets say we want to track a company called Shire.

Inferred Company is = Shire wont work as we cannot preempt all the possible ways a company might appear (i.e. Shire UK , Shire US etc.)

The problem is that if there's inferred companies like Lancashire city council or Buckinghamshire etc. the smart list would pick these up too.

So unless there is a 'match whole word' condition we would have to monitor manually and add exclusions. And that's only one of 100+ companies... so doing it manually is quite a task.

Is there anyway to make this more intelligently?

thanks

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

2 replies

Jim_Thao7
Jim_Thao7
Level 8
February 1, 2017

Try adding a filter for contains "mod" and then another filter for not contains "module".  Filter logic should be ALL.  You should get results for items such as "modular" and "modification" but not "module".

A
Anonymous
February 1, 2017

Thanks Jim

Unfortunately that wouldn't work as we wouldn't know what to exclude.

What we need is to be able to match whole words as opposed to part of words, if that makes sense.

A
Anonymous
February 1, 2017

Hi Yannis,

If there is a list of specific words you can use the "is" and then just add all the words to the list you are looking for. When you list them they are all or statements.

    Nicholas_Manojl
    Nicholas_Manojl
    Level 8
    February 2, 2017

    The only issue would be if the requirement is genuinely needing a "contains": ie, "Andy Mod", "Mike Mod", "Andy Module".

    If you only wanted to search for "Mod", and not "Module".

    A
    Anonymous
    February 2, 2017

    You are right Nicholas, I've updated my original question so the challenge is more clear!

    thanks,

    y.

    Terms & ConditionsAccessibility statement

    Loading footer...