I have a couple excel files (CSV format), that have hundreds of thousands records (or more). I need to export all records that contain zip codes from a list I have (multiple zips) to a new csv file so that I can import them into our leads file in CRM (Outlook). This part we know how to do, its just getting the records exported from the csv into a seperate csv, based on the zips.
For instance:
3 CSV files ----> export all records containing zip codes 03120, 05950, etc (list of 300+ zip codes) ----> New CSV file with only records that contain the specified zip codes.
I also need duplicates filtered out as well. Simple enough project. I don't have time to do it.
Dear Hiring Manager,
I want to do this "Excel Export by zip from large records" project now, let's start immediately. I have read the job description. Please read my PM
Regards,
Oliver