Combine CSV files

Kudose

Hello all.

I am fairly new to the world of CSV files when it comes to PHP.

I have looked around and have pretty much figured out how to read from CSV's and the likes.

But what I want to do is combine several CSV files into one.

I am looking to create a script that will read from a CSV files, look for a certain variable, and insert it into the DB.

But I dont want to have to read from 4 or 5 different files, as the system is setup.

I would like to take the files acquired and combine them into one large file, so I only have to scan once.

Anyone know how to do this?

Would I just append the next file to the previous one? Is there a way to combine them and reorder the file in a certain order after combined?

Thanks!

devinemke

Originally posted by Kudose
I am looking to create a script that will read from a CSV files, look for a certain variable, and insert it into the DB.

use [man]fopen[/man] and [man]fgetcsv[/man] to iterate thru the CSV and conditionally insert lines to the db.

Originally posted by Kudose
Would I just append the next file to the previous one?

grab the contents of the CSV's into strings using [man]file_get_contents[/man] and stitch them together using the concatenation operator then write it all back to a new CSV using [man]fwrite[/man].

Originally posted by Kudose
Is there a way to combine them and reorder the file in a certain order after combined?

spool all of the CSV's into one big array and use [man]sort[/man].

Kudose

Thanks for all of that. 🙂

One more thing, how hard would it be on the server (time and memory wise) to read from a CSV that has roughly 200,000 lines.

It will just scan for one line and pull it, as stated before. Based on user input.

Thanks again.

Kudose

Anyone able to tell me the stress it would cause? Or how long it would take to process?

Thanks again.