Đang Thực Hiện

163805 Excel CSV to filtered CSV

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.

Kĩ năng: Bất kì công việc gì, Nhập liệu, Microsoft Access, MySQL, PHP, SQL

Xem nhiều hơn: need someone to do a excel project, test to take, think straight, excel advanced, csv to excel, advanced excel, php process csv, excel categories, excel file mysql, excel project use database, php excel csv, script process excel files, data entry excel mysql, advanced filter, write test script, file filter excel, data program excel, excel data filtering, write file excel, filtering excel, excel filtering, filtering data excel, php filter csv, write script data entry, create mysql filter

Về Bên Thuê:
( 17 nhận xét ) Kansas City, United States

ID dự án: #1909996