Smart list based on email extension | Community
Skip to main content
Matt_Lyman
Level 2
Sep 11, 2017 4:18 PM UTC
Solved

Smart list based on email extension

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

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
Sep 11, 2017 4:33 PM UTC

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).

3 replies

Matt_Lyman
Level 2
Sep 19, 2017 8:22 PM UTC

Super helpful and looks to have worked! Thanks!

Translate
SanfordWhiteman
Level 10
Sep 19, 2017 8:34 PM UTC

Good to hear! Maybe zap my answer as Correct?

Translate
SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
Sep 11, 2017 4:33 PM UTC

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).

Translate