Deepak
Excel Ninja
To Share a tiny methods which facilitates itself with large tasks.
You are also welcomed to share the tips...
Merge Multiple txt/csv files if they having the same layouts.
Open notepad & copy below code to it.
Now Save it to as copy.bat in same directory where all txt/csv files are exists.
Double Click & Done...
It will merge the all txt/csv file in a single named all.txt/csv.
If you want to re- run the same then either delete or rename the all.txt/csv file before hitting the same else it will re-add the all files data in addition to what it already have.
You are also welcomed to share the tips...
Merge Multiple txt/csv files if they having the same layouts.
Open notepad & copy below code to it.
Code:
copy *.txt all.txt
copy *.csv all.csv
Now Save it to as copy.bat in same directory where all txt/csv files are exists.
Double Click & Done...
It will merge the all txt/csv file in a single named all.txt/csv.
If you want to re- run the same then either delete or rename the all.txt/csv file before hitting the same else it will re-add the all files data in addition to what it already have.