I need a very simple web based script that allows me to upload a CSV file and then the script does the follow:
1) Remove duplicate email addresses. It should remove the entire row of data.
2) Separates “Role Account” emails, such as: sales@, support@, info@, etc. into a separate CSV file. It should allow me to enter these specific keywords into a comma separated text field like this: sales,support,spam,info,abuse
It should produce three CSV files for download: one that has the new "cleaned" list, one that has all of the duplicates, and one that has all of the "role accounts".
This needs to be able to handle processing a single file with 50,000,000 records. That is 50 million records. No exceptions.
It could use a MySQL database for this. No desktop software solutions.
Small budget project.