Smart list based on email extension

Forum|Forum|8 years ago
September 11, 2017
2 replies
2451 views

Hey everyone,

We are trying to build a smart list of any email addresses that contain an extension from a specific country. The problem is that the logic only has "contains" or "starts with"

The issue that arises is when you say: contains .ca you end up with email address that might be matt.campbell@email.com not just ones ending in .ca.

Anyone have any ideas on the best way to do this?

Thanks,

Matt

Marketo

Best answer by SanfordWhiteman

Create another field that's the email address followed by $.

Search on contains ".ca$"

Note choosing $ isn't a coincidence (it's the regex anchor for the end of a string, so your filter makes some visual sense).

Matt_LymanAuthor

New Participant

Super helpful and looks to have worked! Thanks!

SanfordWhiteman

New Participant

Good to hear! Maybe zap my answer as Correct?

SanfordWhitemanAccepted solution

New Participant

Create another field that's the email address followed by $.

Search on contains ".ca$"

Note choosing $ isn't a coincidence (it's the regex anchor for the end of a string, so your filter makes some visual sense).

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded