#1 : 14/03-18 05:36 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 |
#2 : 14/03-18 07:08 Mark
Posts: 175
|
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. |
#3 : 16/03-18 05:11 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 |
#4 : 16/03-18 07:37 Mark
Posts: 175
|
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 |
#6 : 17/03-18 09:17 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 |
#7 : 17/03-18 11:32 Mark
Posts: 175
|
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 |