Batch rename using text file for new name Solved/Closed

Question

Hello,
I am batch exporting filenames and I have no control over the ouput name of each file. I need to rename each filename to a specific standard. I have created a text file that has the exported filename in one column and what the filename should be renamed to in another column.
Is there a way to write a script that can use the text file to lookup the old name and rename it to the new name?

SenHu · Accepted Answer

You have the old name and new name in two columns in a file. I will call the file "names.txt". Here is the script that will rename all of them in a batch.


var string names ; cat "names.txt" > $names
while ($names <> "")
do
    var str line ; lex "1" $names > $line
    var str oldname, newname ; wex "1" $line > $oldname ; wex "1" $line > $newname
    system rename ("\""+$oldname+"\"") ("\""+$newname+"\"")
done

This script is in biterscripting. You can download it free from http://www.biterscripting.com . It installs in minutes.

Save the script in file C:\Scripts\rename.txt. Start biterscripting. Enter the following command.

script rename.txt

It will rename all the files one by one. Then export them.

Email me if you need more help.

Sen

alan · Answer

thanks but there's one problem. My filenames have spaces. I tried using quotes but that did not work. How do I get the script to recognize the spaces in the filenames.

SenHu · Answer

Alan:

How are the two columns (oldname, newname) in the list file separated ? By tabs ? Commas ? (If your file names have spaces, the two columns can NOT be separated by spaces.) The script is using the wex command to extract the columns, The $wsep is the variable that contains all possible separators.

If your columns are separated by tabs, add the following one line at the very beginning of the script.
set $wsep = "	"

If your columns are separated by commas, add the following one line at the very beginning of the script.
set $wsep = ","

That should take care of it.

Feel free to email me further questions.
Sen

Bookworm · Answer

HI,

I am new to biterscripting. I have a same problem and I was trying your solution . It did show me rename and my old name and new name of the files but it was throwing an error "system cannot find the files" I tired copying the files in c:\script also but it didnt work
what should be the path of the old files . I have to rename the batch of ".wav" files. Here si the output when I run the rename .txt files.


script rename.txt
The system cannot find the file specified.

C:\Scripts>rename "NewWaveSound.wav" "sweta.wav" 

The system cannot find the file specified.

C:\Scripts>rename "NewWaveSound(3).wav" "pewet.wav"

SenHu · Answer

Hi Bookworm:

Your old file names and new file names are specified without path. So, for biterscripting to find them, biterscripting has to be in the same folder where the old files are. For example, if your old files are all in one folder C:\Folder, add the following command at the top of the rename script.

cd "C:\Folder"


Then the script should work correctly. If the old files are not all in one folder, you would specify the old files with full paths.

Sen

zorbaam · Answer

i would like to suggest you a program http://www.batchfilerenamer.com

garik · Answer

Hey, don't worry if your file name have spaces, even then you can batch them by using  BatchRenameFiles Tool. 

Just go for it and let me know.

Regards
garik

Batch rename using text file for new name

7 responses

Similar discussions

Subscribe To Our Newsletter!