Any command-line or batch cmd to concatenate multiple files?

Question

I have 50 text files in one dir.

Is there a Windows command-line method to concatenate those files into a single file?

I am using Windows Vista.

I don't want to type the name of all files.

Answer 1

I don't want to type the name of all files.

that's easy to be avoided, open a command prompt in this folder and type the following command:

copy /b *.txt newfile.txt

Press Enter

Now you will have all text files in this folder merged into a single file called newfile.txt

Update

my ultimate aim is to store the contents of each text file in separate column of excel sheet.

why didn't you say that in your question? :)

here's a tutorial that may help you to achieve your "ultimate aim":

Merge all CSV or TXT files in a folder in one worksheet

Answer 2

Assuming you are talking about appending text files,
the 'copy' command can be used to append them together.

copy file1+file2+file3 targetfile

If you have a lot of files, you could loop by appending one file at a time.
^{Its been some time since I used DOS commands...}

Also, if its binary files, you can add in the '/b' option at the end.
This is assuming you know what binary files you are working with and that they can be appended back-to-back -- else, you will get a lump of useless data.

Answer 3

To add a newLine at the end of each concatenated file, use type instead of copy, as follows:

type *.txt > newfile.txt