Having trouble with Batch Renaming

[MVPStudios]

Hello,

I am producing a yearbook where I'm getting the photos from another photographer.  The people in the photos (recruits) are identified by a "proof" number, which associated with their name in the data file.  That proof number is part of the file name of their photo, but only PART of the filename.  I need to rename the files to ONLY contain the proof number.  For example;

Name - Joe Smith

Proof Number - 612017

His image has a file name of 00612017-265.

I learned that it can't be done in Lightroom but that Bridge has a String Substitution tool.  I was able to use it to remove the initial 00 that is at the beginning of every file name.  However, the last 3 digits change for each file and I can't figure out how to remove them and the dash "-".  Even if I have to run it in 2 batches I'm fine doing that.  It is hundreds of different images every week so manually doing it is a nightmare. 

Thanks in advance for your help!

Andy

[Paul Riggott · Accepted solution]

Download and install the Replace Rename script from here:-

http://www.scriptsrus.talktalk.net/Renamer.htm

Select all the documents you want to rename

Run the script..
Tools - File Renamer

To remove the 00 at the begining of the files
Enter ^00 in the replace field and leave the "with" field blank and click ok
This should remove the leading zeros

To remove the - and last three numbers select all the documents again
Enter -\d{3}$ into the Replace field and leave the "with" field blank and click ok

Job done.

Just do a test on a couple first to make sure all is well!

[MVPStudios]

You are the man!  Worked well.  I really appreciate it!