Rename large amount of files

Post any Bulk Rename Utility support requirements here. Open to all registered users.

Rename large amount of files

Postby jsf004 » Fri Mar 05, 2010 12:22 am

Hello! I have a large amount of files I need to rename in my archives. The file names look like this:

pa20854CemeteryPromises_Cvr1.pdf
pa20854CemeteryPromises_Txt1.pdf

And I need them to look like this (respectively):

1424193168_pap.pdf
1424193168.pdf

I have an Excel spreadsheet .XLS with the "pa20854" and "1424193168" linked on the same row. Is there anyway I can get this to convert multiple (10,000+) files the way I need them? I hope this ? isn't too confusing thatnks for your insights in advance!
jsf004
 
Posts: 1
Joined: Fri Mar 05, 2010 12:18 am

Re: Rename large amount of files

Postby Stefan » Fri Mar 05, 2010 4:01 pm

jsf004 wrote:Hello! I have a large amount of files I need to rename in my archives. The file names look like this:

pa20854CemeteryPromises_Cvr1.pdf
pa20854CemeteryPromises_Txt1.pdf

And I need them to look like this (respectively):

1424193168_pap.pdf
1424193168.pdf

I have an Excel spreadsheet .XLS with the "pa20854" and "1424193168" linked on the same row. Is there anyway I can get this to convert multiple (10,000+) files the way I need them? I hope this ? isn't too confusing thatnks for your insights in advance!

Hello

you would need both old and new name in full, not only such parts as "pa20854" instead of "pa20854CemeteryPromises_Cvr1"

Then you would be able to do this with BRU.
* load your file in BRU
* select all files an right click >> context menu >> Clipboard > Names
* paste this names into an excel sheet
* in the next column enter an pipe-symbol '|' and copy this down to all rows (read excel help or google to automate this (and explain us how to do) )
* in the next column paste your new name
* save this as text file
* read the help file "Renaming From A Text File"
* import the text file into BRU with "File > import Rename-Pairs"

Check out the help file >>>> "Renaming From A Text File"
Stefan
 
Posts: 736
Joined: Fri Mar 11, 2005 7:46 pm
Location: Germany, EU


Return to BRU Support