filter ".ca" email domain contacts in a smart list | Community
Skip to main content
A
Anonymous
April 21, 2016
Question

filter ".ca" email domain contacts in a smart list

  • April 21, 2016
  • 1 reply
  • 1826 views

Hello everyone,

I have to pull out a list of all the contacts with Canadian email address i.e of ".ca" domain. I particularly need help since if I create a smart list with filter "Email Address contains .ca" it is pulling out other contacts too such as "honglei.calvin@xyz.com". Is there any way I can only filter out only those emails which ends with ".ca" domain?

Thank you in advance.

Harshit

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
SanfordWhiteman
Level 10
April 21, 2016

Very similar to a recent Community question, so be sure to search first.

You can't do this kind of pattern matching.  I recommend maintaining a separate custom field for the public domain suffix.  You can populate this field using a webhook or import/export, or if you use SFDC you can compute it there. The more fields you split it into, the easier it is to use Marketo's rather limited string matching rules.

A
Anonymous
April 25, 2016

Apologies, I should have searched through the community questions first. I am a new user so I don't know the guidelines/navigation.

Also thank you so much for your response, I will make sure to implement your suggestion.

Terms & ConditionsAccessibility statement

Loading footer...