AnsweredAssumed Answered

Spaces in Filters

Question asked by Mariesa Milan on Mar 7, 2016
Latest reply on Apr 6, 2018 by Sanford Whiteman

I'm creating a Smart List for scoring purposes and I want to include titles with IT. Examples: Director of IT, IT Manager, IT Security, etc.  Since there are many title variations that will include "IT", I do not want to use an exact match. Is there a way to locate titles that include "IT" but also exclude words with "it" in them? Examples of words with "it" in them that we would want to exclude are architect, unit, critical, etc. There is a way to build a filter formula in SFDC that will include spaces - example: CONTAINS( LOWER( Title ) , " it")  -- Notice the space before the " it".  Is there a way to do something similar in Marketo?