Author Topic: Excluding some email addresses (Read 260 times)

tastrax · February 05, 2015, 02:58:05 pm

HI Folks,

We have a database with about 5000 current members and about 40% of those don't have a legitimate email address. Because we are linked to a wordpress site all these clients have a false email address with some specific text in it so we can find them (wildcare+badmail.... then other text). My problem is we cant seem to work out a search /smart group that only gives us real email addreses.

We can find all the false ones with a LIKE wildcare+badmail% but we cant exclude these from a listing.

"Does not equal wildcare+badmail%" does not work and there doesn't appear to be a NOT LIKE function?

Any clues appreciated

Cheers - Phil

Dave Greenberg · February 05, 2015, 03:06:37 pm

This should work if you can 'find' the bad ones:
- Create a smart group from that search.
- For CiviMail mailings, use the Exclude Group option.
- For other purposes (e.g Export ...) - the Include / Exclude Search under Search > Custom Searches should do the trick.

tastrax · February 05, 2015, 03:32:23 pm

Thanks for that - makes sense but I am still curious why "does not equal wildcare-badmail%" does not exclude these emails.

JonGold · February 05, 2015, 03:44:58 pm

Hi Tastrax,

The answer is rooted in how databases interpret "equals" and "does not equal", and isn't specific to CiviCRM. There's a somewhat technical answer here (check the top-voted answer): http://stackoverflow.com/questions/543580/equals-vs-like

CiviCRM Community Forums (archive)

News:

Author Topic: Excluding some email addresses (Read 260 times)

tastrax

Excluding some email addresses

Dave Greenberg

Re: Excluding some email addresses

tastrax

Re: Excluding some email addresses

JonGold

Re: Excluding some email addresses