Renaming from Excel file containing old and new names

[klausdetlef]

Hi

I have an issue, where I have to rename 850 (EPS) files, from one specific name to another specific name. F.x:

From "5702015124974.eps" to "30067_29_UPS.eps"
From "5702014767844.eps" to "30068_29_UPS.eps"
From "5702013423452.eps" to "30123_39_UPS.eps"
... and so on ...

I have an Excel file containing the "from name" and the "to name".

Is it possible to do this in Total Commander?

Best regards

Klaus

[umbra]

Since you have it in Excel, probably the easiest way is to create a text file so it content looks like this:

move:"<path_with_old_filename1>" -> "<path_with_new_filename1>"
move:"<path_with_old_filename2>" -> "<path_with_new_filename2>"
move:"<path_with_old_filename3>" -> "<path_with_new_filename3>"
...

For example

Code: Select all

move:"c:\folder\5702015124974.eps" -> "c:\folder\30067_29_UPS.eps"

When you have that file prepared, click in TC on menu "Net" -> "FTP download from list...", select the created text file and press OK. That should do it.

edit: added double-quotes - not necessary but it's safer with them

[silencer]

You can also use the multi rename tool with the load names from file option.

Just create a txt file with the new filenames and load them. Only thing is that you have to make sure the sorting is the same as in you excel.

[umbra]

2silencer
I totally forgot about that
If klausdetlef really wants just to rename a bunch of files that are all in the same folder, that he can make sure that their order is right and doesn't want to move/copy them somewhere else afterwards, then this will be a bit simpler. And probably more obvious.

[klausdetlef]

Hi

Thanks for your answers. Umbra's solution worked for me

The other solution makes it a bit more difficult because of the sorting of the files.

/Klaus