HUGE file renaming...

[johnwhite]

hi there,

i have just been tasked with a horrible project at work, can anybody please offer any suggestions on ways to speed things up or ideally some software that will help automate the process...

- i have a folder with 2500+ files in it with the filenames in many different formats (ie firstnamelastnamedob / lastnamedob / lastnamefirstname).

- each file needs renaming to a standard format (lastname,firstname, [uniqueid])

- i already have a table of lastnamefirstname and unique id

thanks,

John

[johnwhite]

some success,

i have managed to create in excel a table of *existing filenames* and *new filenames*

does anybody know of a means by which i can automate the process by which existing filename is replaced by new? all files are in the same folder.

thanks in advance,

John

[marek_mar]

TotalCommander or PowerGREP can mass-rename files with regex but I am unsure if that would be of help in your situation.

[Roelf]

create a large .cmd file from the excel shaat where each line is a rename command.

rename "oldfilename" "newfilename"

execute the cmd file

shouldn't be so hard if you have the excel already