Email Address starts with

[Anonymous]

Is there a way to filter email addresses by ends with? 

Many lead in our database have empty countries but their email ends with a country suffix.  For example @yahoo.com.au.  This one has an empty country but the email ends in a country suffix of .au so we know this is an Australia lead.

For known leads with empty countries we would like to use an email ends with filter.  To identify these emails and add the country based on the email suffix.

The closest filter I can find is email address contains. 

Thanks for your help.

[Anonymous]

I've also seen people use inferred country to supplement empty country fields. Granted, it is based on IP info and the drawbacks that come with that. 

[Anonymous]

Nice. This will work well...:)

[Anonymous]

Yes, no second ".".  Should have put quotation marks on my example.  "@yahoo.com.au"

The one I am testing with I currently have filtered to;

Anonymous is False
Country is Empty
Email address contains ".com.au"

I am just testing wtih Australia because it is one of our larger groupings but I intend on cleaning all countries.

[Anonymous]

wait...you don't have the second "." here...may need to think on this one a bit 😉

[Anonymous]

do email address "contains" .au. Not ideal but should work...