Multiple rename from a list

Advanced Renamer forum
#1 : 14/03-18 05:36
Jonathan
Jonathan
Posts: 7
Dear All,

I was wondering if I could rename multiple files using a list of names - say from an excel spreadsheet.

Lets say the list in Excel was :

Helen Harrison
Joan Scott
Debbie Young

Then I would like the files to have the following names :

Helen Harrison Melb Australia 0001
Joan Scott Melb Australia 0002
Debbie Young Melb Australia 0003

I am going to have 13,000 names that I will change in blocks of 200 to 700

Cheers,
Jonathan


14/03-18 05:36
#2 : 14/03-18 07:08
Mark
Mark
Posts: 170
Reply to #1:
Check out https://www.advancedrenamer.com/user_guide/metho d_list

Maybe 2 methods ...

Method 1, List (using your Excel as the source)
Method 2, Add (using " Australia <Inc Nr:1>" at Index 999)

You might need to take care with the number padding.

These can run in one batch.


14/03-18 07:08
#3 : 16/03-18 05:11
Jonathan
Jonathan
Posts: 7
Reply to #2:

Dear Mark,

Thanks for that.

Method 1 - I can generate the list in Excel and then just just copy and past the whole list into the "List Method". Job's done

Method 2 - I don't understand it, but I am always interested to learn.

Cheers,
Jonathan



16/03-18 05:11
#4 : 16/03-18 07:37
Mark
Mark
Posts: 170
Reply to #3:

OK, let's assume you have processed Method 1, the you would have a file with the name like “Helen Harrison Melb”.

You said you wanted “Helen Harrison Melb Australia 0001” so you have to use another Method to add the “ Australia 0001”.

So, with the files ready in the main window, go to the left window and select “Add batch method”, choosing “Add”, with the following parameters:

Add: “Australia <Inc Nr:1>”
At index: 999
Backwards: not ticked
Use regular expressions: not ticked
Apply to: Name

This will literally add the text to the end (999 seems to work at finding the end!) of your names. You should see this in the main window (New Filename).

Also, see https://www.advancedrenamer.com/user_guide/tags_ default

Mark









16/03-18 07:37
#6 : 17/03-18 09:17
Jonathan
Jonathan
Posts: 7
Reply to #4:

Dear Mark,

Thanks for that.

I get the idea, but where do I actually insert the commands/code/instructions for the following, and what do they actually do or not do ?

At index: 999
Backwards: not ticked
Use regular expressions: not ticked

Cheers,
Jonathan


17/03-18 09:17
#7 : 17/03-18 11:32
Mark
Mark
Posts: 170
Reply to #6:
Open AR

The left side is the Renaming Method List. A "Method" enables you to rename, add an increment to a name, etc.

Select "Add Method", choose "Add"

You see a new mini-screen with boxes to enter values. Click the "?", bottom right of that mini-screen: https://www.advancedrenamer.com/user_guide/metho d_add

Add
Specify the text that should be added.
Note: You can use tags here.

At index
Use this to tell Advanced Renamer at what position in the filename the text should be added. If you want to add it to the beginning of the file, set the index to 1. If the index is longer than the filename, the text will be added to the end. If the value is non-numeric the index will be set to the index of the pattern supplied.

Backwards
Use this to make Position count from the end of the filename. If you check this, set Apply To to name and set Position to 1, the text will be added just before the last "." (the extension separator).

Regular expressions
See https://www.advancedrenamer.com/user_guide/regul ar_expresions

Use some test files, and just play ... enter values in the boxes, you'll soon see what effect they have.

Mark


17/03-18 11:32