A simple way to modify file names in batches

I met a friend today. Q: How do I batch modify file names? The original file name does not have rules, such as employee number or student number, the modified file name is the name or ID number. Let's say a simpler way to solve the problem of batch file name modification .

The whole idea: we need to have a corresponding relationship between the original file name and the new filename, and then use the batch bat file to ren the rename command.

Find a practical case for a little more detailed explanation: if we want to change the original employee number to the name of the photo file ID number is the name of the file.

The first step, we should be from the financial or personnel to the people's information table, it is not, we can do one, with Excel to make, the following diagram of a, b column, and then use the Excel formula to generate column C = "ren" &A2& ". jpg" &b2 & ". jpg" here uses a word linked formula for Excel, do not understand can be directly copied to use, if you want to find out the details of the relevant knowledge of Excel, need to pay attention to each & symbol before and after the need for characters (the need to use the English state of double quotes, such as "Ren or cell name (no quotes, such as A2) are required.

In the second step, all the generated content in column C (excluding the header cell) copy, click "Start" "Attachment" "notepad", paste, Save as a bat file (save type Select "All Files", and then enter a batch modification at the file name. bat).

In the third step, put the generated bat file in the folder where you want to change the file name, and double-click.

The example above is for file names without rules, and if the original file name and the newly generated file name have certain rules, you can use Excel to drag and drop the build or use formulas and functions to generate a new file name.

If the file name already has a suffix in the example above, it is better to do, directly in a column before adding a column, all input ren and then do not what formula generation, directly to the three-column data copied to Notepad, save as a bat file, the bat file copied to the Picture folder, double-click it.

We know from this example that the core is the bat batch and the ren Rename command. Learn this you are not afraid to later name a large number of files, after all, downloaded from the Internet to modify the file name of the program can not solve all your problems, especially if your file name is not the rules of the name.