Wilbur13 wrote:Hello i have a question about the list rename.
i have a couple of thousand files is need to rename based on their original name.
e.g.
AB123.456.jpg --> Category-name-AB123.456-article-name.jpg
The category and article name vary per file and i get those out of an excel list.
AB123.456.jpg|Category-name-AB123.456-article-name.jpg
So far so good, no problems here.
My problems begin wit files which belong together and are named thus:
AB123.456.jpg
AB123.456(1).jpg
AB123.456(2).jpg
AB123.456(3).jpg
I would like to change all names in one batch but my excel list doesn't know about the multiple files per item.
Is there a way to make BRU rename alle the files via a rename-pairs and keep the (1) number in the name?
If you have more files on the disc then in you excel list then you have an problem anyway
because the "Renaming From A Text File" option will rename each file on disc with just the next line from the excel sheet.
F.ex. you have this files
a.ext
b.ext
c.ext
c(2).ext
c(3).ext
and this excel list
aa.ext
bb.ext
cc.ext
dd.ext
ee.ext
then your files will be renamed like
- Code: Select all
a.ext ==> aa.ext
b.ext ==> bb.ext
c.ext ==> cc.ext
c(2).ext ==> dd.ext
c(3).ext ==> ee.ext
So i think you have to do some work on the excel sheet first:
* select all files in BRU and export the name to clipboard (right click menu)
* create an new sheet in your excel file and paste the names in
* write an VBA script to parse all lines and add additional row as needed for the additional files(1).
like
aa.ext
bb.ext
cc.ext
cc(2).ext
cc(3).ext
dd.ext
ee.ext
---