Merge multiple text files with the dos command, and combine text files with the dos command

Merge multiple text files with the dos command, and combine text files with the dos command

Author: iamlaosong

There are 30 text files from the trunk line data under the Headquarters system, and you want to convert them into an Excel file by combining the text with the copy command, opening the file with excel, and saving it as an Excel file. The procedure is as follows:

1. Copy all text files to the same folder, click Start> Run, And Enter cmd to open the Command Prompt window and switch to the location where the text files are stored, for example, in the e: \ temp Directory, enter "e:" And press enter, and then press "cd \ temp" to go to the file location. As shown in:

2. Enter "copy *. txt song.txt((song.txt) and press enter to run the command. If there are other files in the directory, you only need to extract the common features of the file name to be merged, such as "copy log *. txt song.txt"

3. Enter the "dir song.txt" command to view the merged text file. As shown in:

4. Open it in excel and save it as an Excel file.