Sunday 27 September 2009

How to merge multiple .csv files into one .txt file using command line

Create a folder on your c: drive called 'All csv files' and place all of your .csv files inside.
Open notepad and add the text below
cd C:\All csv files

copy *.csv Merged.txt

Save the text file and changed its extension to .bat 'merge.bat'.
Double click the file and you will see that a txt file is created in the C:\All csv files folder called 'Merged.txt' with all your consolidated information inside !.

No comments:

Post a Comment