Joining / Merging csv files into one

[ICI-MASA]

Hi,

is there a way to join or merger a bunch of csv files into one file?

regards
Martin

[Dan_Bracuk]

Read them all with cffile. Write a new one with cffile. Details are in the cfml reference manual. If you don't have one, the internet does.

[ICI-MASA]

Thx Dan, for the reply, well I have the reference manual right in front of me, and I thought about using cffile, but my experience has been that cffile is very slow so merging say like 20 - 30 files into one with 600 records in each would be somewhat time consuming or if even possible? does anyone know?

regards
Martin

[Dan_Bracuk]

By the way, by merging, do you mean simply concatonating or doing some other stuff eliminate duplications.

Not sure about what you find slow with cffile. It's not something that I noticed.

[Stressed_Simon]

If you are using mysql then you can use the csv table engine which will make life alot easier as you can easily read them into a db then use sql to merge.

[ICI-MASA]

Thx for the tips, will have a look at the csv table engine..