Matching & Removing
Posted on 2010-01-12
I've a situation, have a list of email address, almost 5000, when I send to them an email, got some back with some error, let's assume they are more than 2000.
Keep in mind in these they came back with different headings:
From: Mail Delivery System <firstname.lastname@example.org>
Subject: Mail delivery failed: returning message to sender
From: Mail Delivery System <MAILER-DAEMON@p02c11m025.mxlogic.net>
Subject: Mail delivery failed
From:mailer-daemon@<so and so>.com
From: postmaster@<so and so>.COM
From: Mail Delivery Subsystem <mailer-daemon@<so and so>.com>
Subject:Delivery Status Notification (Failure)
From:Yahoo! Groups <email@example.com>
Subject:Unable to deliver your message
some more subject lines are unable to deliver or failure notice or Delivery Notification
and now there is 2nd category, where got out of office or Vacation reply or whatever
Now the question, how to remove these failure ones in a separate list and these out of office ones in seperate one, because they are good ones, but the person is not there at this point in time or either he/she asked to send to some other email address.
Basically would like to segregate the good ones with the bad ones, or either can say, those which are not working at this point in time.
I know this is a little confusing question, but need some help for cleaning my email database, as it is pretty big.
I can do this cleaning either on linux or windows, whatever and where you want me to do, or if there any tool or any db or any thing, how I can fix this problem, as sending emails to these bogus addresses for quite some time.
Big Thanks in advance, for the one who can fix this problem.