Skip to main content
December 4, 2013
Question

Email Address starts with

  • December 4, 2013
  • 5 replies
  • 1146 views
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.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

5 replies

December 4, 2013
do email address "contains" .au. Not ideal but should work...
December 4, 2013
wait...you don't have the second "." here...may need to think on this one a bit ;)
December 4, 2013
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.
December 4, 2013
Nice. This will work well...:)
December 5, 2013
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.