Job description
I need some solution...
I currently have a mailing list at my company, which is saved in CSV format (Email format - domain)
I also have a database (hosted) with unsubscribe emails - that are emails that did not want to receive any more emails.
I had a script written in Java that filtered these emails for me - written in my heyday but now I have a Java Error Compiler info and can't jump over it so I'd rather move away from that to something new.
I would need a script or web solution which would give me the ability to e.g. upload a csv file (Email structure / domain) -> this solution would connect to the database (unsubscribe), compare newly imported emails with the unsubscribe database, and remove emails which were in the unsubscribe database from the newly imported emails.
Additionally, it would be good if it would be possible to add some conditions to this solution - for example in the field I can enter the word "hospital" and this solution would additionally check if there is an email that has word "hospital" in the name. - it would be good to add more such fields.
The second function is the emails should be grouped by max 2 emails per domain
