I have a lot of data that we use for different purposes.
We have over 1 million records that have categories such as zipcode, state, etc.
There are 26 indidivual Excel CSV files.
I have been using Excel's advanced filter to take all records and filter them by State and then put them in a seperate file. So from 26 CSV's I end up with 26 CSV's filtered by state. So in total I should come up with 50 folders with copies of all 26 CSV files filtered by State. A total of 1,300 CSV files. This is taking me a lot of time!
I need someone to write a script or program to process these excel files or CSV and create individual CSV files all organized by state.
If you understand what I'm talking about and can do this project please let me know.
If you don't have any previous experience with filtering CSV / Database files please don't bid.
If converted to straight CSV files I think that putting these in a MySQL database and running a PHP script to separate them all would work too but I don't have time to figure it out. Let me know what options are available.
I would need to test your script / program and see it work for one state before payment. Thanks for looking at my project.