SOLVED

Smart list based on email extension

Go to solution
Matt_Lyman
Level 2

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

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Smart list based on email extension

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

View solution in original post

3 REPLIES 3
SanfordWhiteman
Level 10 - Community Moderator

Re: Smart list based on email extension

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_Lyman
Level 2

Re: Smart list based on email extension

Super helpful and looks to have worked! Thanks!

SanfordWhiteman
Level 10 - Community Moderator

Re: Smart list based on email extension

Good to hear! Maybe zap my answer as Correct?