Showing posts with label extension. Show all posts
Showing posts with label extension. Show all posts

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 !.