Question

[adamtbigr]

What I want to do is exactly what is expressed in the following topic: http://www.bulkrenameutility.co.uk/forum/viewtopic.php?f=3&t=1303

I have followed the following instructions, I simply do not know how to use the Renaming From A Text File feature listed in step 6. Can someone give me some guidance?

To create this list with Excel do something like this:

1)
Open your sheet
CODE: SELECT ALL
A B
Old Name New Name
Old Name New Name
Old Name New Name
Old Name New Name
Old Name New Name
Old Name New Name
Old Name New Name


2)
Insert new column between A and B
CODE: SELECT ALL
A B C
Old Name New Name
Old Name New Name
Old Name New Name


3)
Add an pipe symbol into the first cell of (new) column B
CODE: SELECT ALL
A B C
Old Name | New Name
Old Name New Name
Old Name New Name

and use the Excel function to copy this content into all cells below to get:
CODE: SELECT ALL
A B C
Old Name | New Name
Old Name | New Name
Old Name | New Name
Old Name | New Name
Old Name | New Name
Old Name | New Name
Old Name | New Name



4)
In column D enter this Excel command
CODE: SELECT ALL
A B C D
Old Name | New Name =A1&B1&C1

and again fill all cells below too
CODE: SELECT ALL
A B C D
Old Name | New Name =A1&B1&C1
Old Name | New Name =A2&B2&C2
Old Name | New Name =A3&B3&C3
Old Name | New Name

so you get:
CODE: SELECT ALL
A B C D
Old Name | New Name Old Name|New Name
Old Name | New Name Old Name|New Name
Old Name | New Name Old Name|New Name



5)
now select column D and paste this list into an text file:
CODE: SELECT ALL
Old Name|New Name
Old Name|New Name
Old Name|New Name
Old Name|New Name
Old Name|New Name
Old Name|New Name
Old Name|New Name


6)
In BRU use the "Renaming From A Text File" feature.


HTH?



BTW, we can also do this with Excel without the additional column,
just use this as command:
= A1 & "|" & B1

EDIT:
i have found an web side about Excel to help you using it:
http://www.mrexcel.com/articles/function-to-merge-two-columns.php
Stefan

Posts: 536
Joined: Fri Mar 11, 2005 7:46 pm
Location: Germany, EU

[Stefan]

I simply do not know how to use the Renaming From A Text File feature ?

Read the help about "Renaming From A Text File"

To use this facility, create a text file in for the correct format, for example:

Track001.mp3|Headlong.mp3
Track002.mp3|Rushes.mp3
TRACK003.mp3|AnywhereIs.mp3

As you see, there is one entry per line.

Next, click the Import option on the File menu and load your file. If the file is valid then you will see the "new name"
column reflecting the contents of the text file.

 

[adamtbigr]

I tried using the help file, I could not find this. Could you please just explain how to do this?

[Stefan]

It is already explained in the quoting. Nothing more to do.

- Create a new text file.
- Enter your old and new name pairs, one entry per line, delimited by a pipe symbol |
oldname.mp3|newname.mp3
- save that file.
- Next, click the Import option on the File menu and load that file.
If the file is valid then you will see the "new name" column reflecting the contents of the text file.



And next time use a more clever Subject for your threads. "Question" is not well chosen.

 

[adamtbigr]

The only import method I see under File is Import Rename - Pairis. When I do this, I do not know what to do from there.

What I do not understand is how does the program know which folder contains the files that need to be renamed?

[Stefan]

 
"Renaming From A Text File" // "Import Rename-Pairs"

(See Help >> Additional Features >> Renaming From A Text File)

- Create a new text file, like "RenamingPairs.txt", best in the BRU folder.

- Open that file and enter your old and new name pairs,
one pair per line, delimited by a pipe symbol "|"

EXAMPLE:
old.mp3|new.mp3
oldname.mp3|newname.mp3
song3.mp3|Madonna - Like a dancer.mp3
Title 4.mp3|Four Boys - Midnight Blues.mp3


As you see, there is one renaming pair per line.
Be sure to trim leading and trailing spaces.
Do not add paths, the files are taken from the folder you will select later in BRU.
Be sure to have the old name exactly written as stored on disc (except for the case). Write the new name as you want it to be.
The code is using UTF16 handling, so it should cope with unicode too. Be sure to save the file accordingly.


- save that file.

- Open Bulk Rename Utility.

- Be sure to have the folder with the files to become renamed selected on the left tree view.
That content will be searched for the file names from the left of your "RenamingPairs.txt" file.

- Click at "File >> Import Rename-Pairs" option to load that file.


If the file is valid then you will see the "new name" column reflecting the contents from the right column of your "RenamingPairs.txt" file.
You may have to selected the files in the NAME column to see in the New Name column what will happen?

When comparing the current filename with the text file the application ignores the case of the filename,
e.g. it will happily match Track001.mp3 and TRACK001.mp3. This makes it easy to rename the files.


Just try it out till you see how it works.



 540