In MS DOS copying several files to one file

Question

I am trying to take a folder that has several  csv files in it and combine all of these files and the information in them  into one file using MS DOS  Any suggestions

User · Answer

type data1 csv  gt  combined csv type data2 csv  gt  gt  combined csv type data3 csv  gt  gt  combined csv type data4 csv  gt  gt  combined csv   etc   Assume that your using files without headers and all files have the same columns

User · Answer

filenames must sort correctly to combine correctly   file1 bin file2 bin     file10 bin wont work properly  file01 bin file02 bin     file10 bin will work properly  c  gt for  i in  file  bin  do type  i  gt  gt  onebinary bin   Works for ascii or binary files

User · Answer

copy   csv new csv   No need for  b as csv isn t a binary file type

User · Answer

copy  b file1   file2   file3 newfile   Each source file must be added to the copy command with a    and the last filename listed will be where the concatenated data is copied to

User · Answer

for  f in  filenamewildcard0  filenamewildcard1       do echo  f  gt  gt  newtargetfilename with path   Same idea as Mike T  might work better under MessyDog s 127 character command line limit

User · Answer

make sure you have mapped the y  drive  or copy all the files to local dir c  local  c  local  copy     c  newfile txt

User · Answer

If this is part of a batch script   bat file  and you have a large list of files  you can use a multi-line    and optional  Y flag to suppresses prompting to confirm you want to overwrite an existing destination file   REM Concatenate several files to one COPY  Y       this is file 1 csv         this is file 2 csv         this is file 3 csv         this is file 4 csv         this is file 5 csv         this is file 6 csv         this is file 7 csv         this is file 8 csv         this is file 9 csv           output file csv   This is tidier than performing the command on one line

[dos] In MS DOS copying several files to one file

Examples related to dos