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

[Anonymous]

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

[SanfordWhiteman]

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.

[Anonymous]

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.