Replace using Spreadsheet

Hi,
I want to replace about 350 image file names which are currently named with a 4-digit identifying code, with an 8-digit identifying code - which I have in an excel spreadsheet.
Column A is the current 4-digit and Column B is the 8-digit I want to change it to.

Is this possible with Advanced Renamer and if so, how?

Reply to #1:

Hi Bianca,

Yes, it's quite easy to do. Look on the menu (usually above the files list) and find "Add / Import / Files from CSV"; that's what you'll be using once you convert your spreadsheet to a CSV file.

Read about it here: https://www.advancedrenamer.com/user_guide/v4/cs vimport

I haven't used Excel in 30 years or so, but you probably just have to use "File / Save as" and then choose "Text CSV file" or something similar That's how it appears in Libreoffice, the spreadsheet I use).

Once you have your file in CSV format just import it into ARen and load your files. That should do what you need.

If you have problems just answer back. :) And remember to check the "New Filename" preview column. If you make a mistake you can use "Tools / Undo batch" on the menu to undo the changes.

Best,
DF

Reply to #2:
Hi DF,
That's not quite it.

The spreadsheet I have has the original file name in column A, and the 'new file name' in column B.

This 'CSV import' option in AR doesn't seem to play 'replace' aka match what is in column A to the original file and rename it with what is in column B. It just seems to replace whatever the current file name is with the 'next' row in column B.

If that makes sense. I think I'll just continue doing it manually.

Reply to #3:
I think the problem is similar to this one: https://www.advancedrenamer.com/forum_thread?for um_id=15665 .
I hope this helps!

Reply to #4:

Hi Styb,

You're right; it's been a while since I've used that stuff and had more confidence than I should have. :)

This works though:

"Add / Import / Data from CSV" imports the two columns.

Then one "Replace" method with:

Replace: <csv:1>
Replace with: <csv:2>
Occurrence: All
Case sens.: Checked
Use regular expressions: Unchecked
Apply to: Name and extension [if you have extensions in your csv file]

Best,
DF