I need a macro that will work in excel (or a php script) that can filter a list that I will provide.
I will have a list that will look like this:
KEYWORDS DOMAIN EMAIL FILTERWORDS
cheap hosting abcdomain.com support(at)b.com support
bad dream 5domain.com suppor(at)5domain.com dsnadmin
yellow ydomain.com support(at)fyx.com
green beedomain.com dnsadmin(at)beedomain.com
bel celldomain.com dnsadmin(at)fdomain.com
fell andomain.com pete(at)man.com
The script or macro, will process the list as follows:
If a word in the FILTERWORDS column appears in the EMAIL column, (anywhere in an email), it will consider that specific row. For that row, if the domain in the DOMAIN column does not appear in that particular email in that row, the whole row will be deleted.
Thus, the list on top, will be result in:
KEYWORDS DOMAIN EMAIL
bad dream 5domain.com support(at)5domain.com
green beedomain.com dnsadmin(at)beedomain.com
fell andomain.com pete(at)man.com
Your script/macro must be able to handle up to 20 000 rows of information (typically it would be about 10 000).
The filter words will typically be 2 to 5 words.
