Skip to main content
Level 2
Oct 29, 2021 10:37 PM UTC
Solved

Wildcard Patterns for Segmenting in a Smart List

Hello all - 

 

I am working on a smart list that is Job Title specific. Does Marketo have the capability to filter by using wildcard patterns? I know some programs use percent signs (%) or asterisks (*).

 

For example, I'd like to pull in CTOs but not Directors (which contains 'cto'). So it should look something like this - % CTO %. However, I've tried numerous iterations of wildcard patterns (and job titles) for testing purposes but it always returns zero contacts.

 

Does anyone have insight into this? Thanks 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jo_Pitts1
Jo_Pitts1Accepted solution
Community Advisor
Oct 31, 2021 2:15 AM UTC

Kyle,

there aren't wild cards but you do have contains and not contains

 

You could create a filter that was along these lines

you may need to use advanced filters to create a combination of Ands and Ors that work for you.

 

Cheers

Jo

 

2 replies

SanfordWhiteman
User Group Leader
User Group Leader
Oct 30, 2021 1:09 AM UTC
Neither SQL wildcards nor other wildcards (grep, regex) are supported.

You can pass people through a webhook for more precise pattern matching.
Translate
Jo_Pitts1
Community Advisor
Jo_Pitts1Community AdvisorAccepted solution
Community Advisor
Oct 31, 2021 2:15 AM UTC

Kyle,

there aren't wild cards but you do have contains and not contains

 

You could create a filter that was along these lines

you may need to use advanced filters to create a combination of Ands and Ors that work for you.

 

Cheers

Jo

 

Translate