Build One Large CSV from exisiting CSV

[Randombard]

Hi All,

I would like to build one very large CSV (couple of million rows) from a set of existing csv's.

Ideally I would like to point the code at a directory and then have it go through file by file and add the rows to the bottom of a new master file.

Each file contains the same headers, just cant get my head around this one.

 

[Richard Schollar]

Do you actually have the headers in each file, or is just the file structure the same? If you don't have the headers and each file ends with either a Line feed then you could use a DOS command to stitch them together.

 

[Randombard]

Right now they all have the same headers.

Bu I can always remove them

 

[Randombard]

used a .bat file build method.

Thanks for kicking me and getting me to remember there are other options