To create a folder/directory using a DOS command, do the following :
Open up a command window i.e. Winkey + R and type cmd into the field and press Enter.
Type : md c:\Testfolder and press Enter
That's it, you will now have a folder called 'Testfolder' on your C drive !
Showing posts with label folder. Show all posts
Showing posts with label folder. 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 !.
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 !.
Subscribe to:
Comments (Atom)