File Renaming

[G.P.Runter]

I'm looking for help with renaming

Here's what the file looks like now:-

8006.jpg
8041.jpg
8049.jpg

*they are not consecutively numbered.

I have a spreadsheet which contains a column with the file name
(number) and another column with a narrative description of the file,
of about 20 characters in length.

Steel_Revelry
Copper_Virtue
Aluminium_Volatile

All descriptions are unique. I want the files to look something like
this:-

8006_Steel_Revelry.jpg
8041_Copper_Virtue.jpg
8049_Aluminium_Volatile.jpg

Basically I want the new file name to be created by concatenating two
columns of the spreadsheet

Any help would be appreciated


GPR

 

[MAMEngineer]

All descriptions are unique. I want the files to look something like
this:-

8006_Steel_Revelry.jpg

Add some columns to your spreadsheet...

rename path:\8006.jpg path:\8006_Steel_Revelry.jpg

saveas text, space delimited and name it something.bat

double-click on something.bat.

Sit back and relax.

 

[Susan Bugher]

I'm looking for help with renaming

Here's what the file looks like now:-

8006.jpg
8041.jpg
8049.jpg

*they are not consecutively numbered.

I have a spreadsheet which contains a column with the file name
(number) and another column with a narrative description of the file,
of about 20 characters in length.

Steel_Revelry
Copper_Virtue
Aluminium_Volatile

All descriptions are unique. I want the files to look something like
this:-

8006_Steel_Revelry.jpg
8041_Copper_Virtue.jpg
8049_Aluminium_Volatile.jpg

Basically I want the new file name to be created by concatenating two
columns of the spreadsheet

One way to do this is to create a list and use an app that can rename
files from a list. I renamed a group of files that way recently with THE
Rename:

http://www.pricelesswarehome.org/2004/PL2004FILEUTILITIES.php#0747-PW

I believe Lupas Rename can also do this:

http://www.pricelesswarehome.org/2005/PL2005FILEUTILITIES.php#0429-PW

more file renamers here:

http://www.pricelesswarehome.org/acf/P_FILEUTILITIES.php#3.20FileRenamer

Susan