I'd like to rename filenames following a list with for example 450 lines and 2 columns. In the first column are the names of files existant, in the second file the new names. The folder with the files to rename only contents 150 files (a third of the complete list).
I tried this, but it does'nt work - neither in "multiple string replacement ('cause one cannot paste a list into), nor in "take names from list" (list.txt was extracted from excel-file).
Example:
4711.jpg rename into 1111.jpg
4712.jpg rename into 2222.jpg
4713.jpg rename into 3333.jpg
and so on...
Thanx for an answer.
Rename a complete list of files
You do not need Ant Renamer when you have such list (well, I agree that I could add in Ant Rename something to use such list... it will be for a future version).
You can in excel put ren in front of each line, have a space between the two names, save the list as a text file in the folder where the files are, rename it with a ".bat" or ".cmd" file extension, and then run it. It will rename all the files.
e.g.:
ren 4711.jpg 1111.jpg
ren 4712.jpg 2222.jpg
ren 4713.jpg 3333.jpg
You can in excel put ren in front of each line, have a space between the two names, save the list as a text file in the folder where the files are, rename it with a ".bat" or ".cmd" file extension, and then run it. It will rename all the files.
e.g.:
ren 4711.jpg 1111.jpg
ren 4712.jpg 2222.jpg
ren 4713.jpg 3333.jpg
Rename a complete list of files
Your tips have been very helpful. Thanx a lot!
-
WayneMacDarret
- Posts: 2
- Joined: 2021-04-07 14:53:09
Re: Rename a complete list of files
Hi, I have a list of 400 pdf to rename and fail with VBA in Excel. I've followed the help folder of the software but the names are not the good ones for the files. For example the files that needs to be rename 0001234 is rename with another number of the list.
Can you please help me renaming the good file with the good name of the list with ant. ?
Can you please help me renaming the good file with the good name of the list with ant. ?
Re: Rename a complete list of files
You use the "From list" action?
It takes items from the list in the same order as the files appears in the "Files" page.
You can use the preview to check which file will be renamed to which name, to see where a problem occurs and why the name is not the expected one.
If you need more help, I'll need more details (and possibly some screenshots).
It takes items from the list in the same order as the files appears in the "Files" page.
You can use the preview to check which file will be renamed to which name, to see where a problem occurs and why the name is not the expected one.
If you need more help, I'll need more details (and possibly some screenshots).
-
WayneMacDarret
- Posts: 2
- Joined: 2021-04-07 14:53:09
Re: Rename a complete list of files
Hi very helpful, It was not working yesterday and this morning I uploaded the files instead of the folder and it has worked perfectly.
So powerfull !!!
Thank you for your help
So powerfull !!!
Thank you for your help