I give you a CSV file looking like this:
First name, Last name, email, date_added, status_ID
Ruddy MINATCHY 2013-09-12 08:10:03 0
Ruddy MINATCHY 2013-09-12 08:11:44 3
vincent MAINFROID 2013-09-12 08:31:47 3
pascal alessio 2013-09-12 07:17:04 0
david grappein 2013-09-12 07:49:13 3
Your job is to edit this file to keep only line with order 0 !!
* IF A SAME EMAIL HAVE 2 or more STATUS AND 1 IS DIFFERENT FROM 0 then we DON'T KEEP THIS EMAIL.
for the file below here is how would look the output CSV (only one line is keep for this example)
First name, Last name, email, date_added
pascal alessio 2013-09-12 07:17:04 0
NOTE : this file get have up to 10 000 lines so shorting need to be optimize and quick :)