Smart List Field Contains Whole Word? | Community
Skip to main content
Ashley_Long
Level 2
April 3, 2019
Solved

Smart List Field Contains Whole Word?

  • April 3, 2019
  • 1 reply
  • 2203 views

Is there a way to limit my smart list attributes to return values that only match a whole word? For example, I'm attempting to pull job titles that contain "OT" (as seen in "Director of OT" or "OT Supervisor"), but keep returning titles like "Director of Emotional Learning" or "Motor Services Coordinator".

I've tried including the phrase in quotations (a la Google search), but that doesn't seem to make a difference. I also tried including a space before and after OT to try to enforce the whole word, but that space is not maintained when the list is generated. We collect a lot of data straight from customers, so there is a lot of variation and listing out all possible options for job titles is not very feasible. Any thoughts?

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

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
April 3, 2019