Smart list based on email extension

[Matt_Lyman]

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 · Accepted solution]

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]

Super helpful and looks to have worked! Thanks!

[SanfordWhiteman]

Good to hear! Maybe zap my answer as Correct?