[help]: Joining 20+ CSV files together

I need a little help as I am a complete novice at programming. i have 20+ CSV files and i need split them together into bigger one. Anyone have solution for this problem? please, help.

 

Why not use Excel or openoffice Calc?

Patrice

 

lol, thanks for advice, it is very valuable .
now i have 200+ files and there are no any tools in Excel or OO to split them together into one file.

 

This should work, assuming you just want to append one file one to the next.

c:\>type a.txt
a

c:\>type b.txt
b

c:\>type a.txt b.txt > c.txt
c:\>type c.txt
a
b

Code (markup):

or to make it easier, since you have so many csv files, place them all into one directory.

c:\csv-files>for %G IN (*.csv) DO type %G >> c:\combined-output.csv

Code (markup):

Note you probably want to redirect the new file to a directory outside where you are working as we have here (c:\combined-output.csv) to avoid reading it in as part of *.csv.

 

If they are csv files and they're on a unix filesystem, you can use the 'cat' command.

cat file1 file2 file3 > bigfile

If you're on windows, you can try using the 'type' command:

type file1 file2 file3 >> bigfile

 

Thanks, guys! These methods really work, exactly what I need. But now i have another question:
this code works in win:

c:\csv-files>for %G IN (*.csv) DO type %G >> c:\combined-output.csv

Code (markup):

Do any one have the same code solution but working on unix?

 

for bash shell:

for i in `ls *.csv`; do
cat $i >> output
done

Code (markup):

or simply

cat *.csv >> out

Code (markup):

 

Thanks again! +1 rep .

 

No problem, glad I could be of help.