Rename Images In Batch/Bulk -- Please Help!

A swapping-ground for Regular Expression syntax

Rename Images In Batch/Bulk -- Please Help!

Postby shizant » Fri Feb 04, 2011 2:28 pm

I need to rename over 10,000 images. I've done this before with the help of a programmer and a .bat file but I need to learn how to do this again and by myself.
My images are saved in separate folders so I don't have to do all 10,000 images at once.
I have an excel spreadsheet with all of the image names (without the .jpg extension). These are in column A. Column B has the name that I want the image to be changed to.

How can I use BRU to look in the excel file for the image name in column A and rename it to the corresponding name in column B?

Step by step instructions would be much appreciated as I am novice and this is my first time using this software.

Please help!

Thanks in advance...
-Shizant
shizant
 
Posts: 1
Joined: Fri Feb 04, 2011 2:23 pm

Re: Rename Images In Batch/Bulk -- Please Help!

Postby Stefan » Sat Feb 12, 2011 6:47 pm

shizant wrote:How can I use BRU to look in the excel file for the image name in column A and rename it to the corresponding name in column B?


Read the help about "Renaming From A Text File"
To use this facility, create a text file in for the correct format, for example:

Track001.mp3|Headlong.mp3
Track002.mp3|Rushes.mp3
TRACK003.mp3|AnywhereIs.mp3

As you see, there is one entry per line.

Next, click the Import option on the File menu and load your file. If the file is valid then you will see the "new name"
column reflecting the contents of the text file.



To create this list with Excel do something like this:

1)
Open your sheet
Code: Select all
A          B
Old Name   New Name
Old Name   New Name
Old Name   New Name
Old Name   New Name
Old Name   New Name
Old Name   New Name
Old Name   New Name


2)
Insert new column between A and B
Code: Select all
A          B    C
Old Name        New Name
Old Name        New Name
Old Name        New Name


3)
Add an pipe symbol into the first cell of (new) column B
Code: Select all
A          B    C
Old Name   |    New Name
Old Name        New Name
Old Name        New Name

and use the Excel function to copy this content into all cells below to get:
Code: Select all
A          B    C
Old Name   |    New Name
Old Name   |    New Name
Old Name   |    New Name
Old Name   |    New Name
Old Name   |    New Name
Old Name   |    New Name
Old Name   |    New Name



4)
In column D enter this Excel command
Code: Select all
A          B    C          D
Old Name   |    New Name   =A1&B1&C1

and again fill all cells below too
Code: Select all
A          B    C          D
Old Name   |    New Name   =A1&B1&C1
Old Name   |    New Name   =A2&B2&C2
Old Name   |    New Name   =A3&B3&C3
Old Name   |    New Name

so you get:
Code: Select all
A          B    C          D
Old Name   |    New Name   Old Name|New Name
Old Name   |    New Name   Old Name|New Name
Old Name   |    New Name   Old Name|New Name



5)
now select column D and paste this list into an text file:
Code: Select all
Old Name|New Name
Old Name|New Name
Old Name|New Name
Old Name|New Name
Old Name|New Name
Old Name|New Name
Old Name|New Name


6)
In BRU use the "Renaming From A Text File" feature.


HTH? :D



BTW, we can also do this with Excel without the additional column,
just use this as command:
= A1 & "|" & B1

EDIT:
i have found an web side about Excel to help you using it:
http://www.mrexcel.com/articles/function-to-merge-two-columns.php
Stefan
 
Posts: 736
Joined: Fri Mar 11, 2005 7:46 pm
Location: Germany, EU


Return to Regular Expressions