I have about 20 folders and all of them have around 100 csv files each. I want to combine all of them together into one file. How should I do this? I know about
copy command to combine files of one folder. If I do that, I get 20 files in 20 folders. To combine them, how will I traverse in each folder and do ?
I am trying to write a batch script like this:
FOR /D /R %G in ("*") DO ( cd %G COPY *.csv new.csv )
But, it is not working correctly. Any suggestions?