Sunday, March 11, 2007

Merging many text files into one file

This one is so simple it hurts.
If you have many text (CSV, TXT, HTML, etc...) files that you need to combine into one file, follow these instructions

Merge all data from the csv files into a text file

1) Windows Start Button | Run
2) Type cmd and hit enter ("command" in Win 98)
3) Go to the folder with the CSV files (for help enter "help cd")

4) Type copy *.csv all.txt and hit enter to copy all data in the files into all.txt.

5) Type exit and hit enter to close the DOS window

Modify a bit depending on the file types.....From Ron de Bruin's excel page

Update: ' /b' is needed in some cases (ctrl-z)

No comments: