merging file names from external source

Advanced Renamer forum
#1 : 04/02-19 18:36
Bob
Bob
Posts: 1
i have a list of image files i1.jpg, i2.jpg, i22.jpg (about 2000)
I have a table of short descriptions that i would like to merge into those file names
ex lamp
door knob

these are in a file, say a 2000 row csv file has a column with the i1, i2, i22 for a cross reference to the image files...so a typical row would be
lamp i1
door knob i2

so i'd like to rename the file i1.jpg to i1-lamp.jpg
i2.jpg to i2-door knob.jpg

? thorny issue and appreciate any help in advance...

Bob


04/02-19 18:36 - edited 04/02-19 18:37
#2 : 04/02-19 21:16
David Lee
David Lee
Posts: 153
Reply to #1:
Should be straightforward using "Import"=>"Files from CSV..." to load the source filenames into the list and the corresponding new filenames into the List method.

You will need to edit your csv file so that source filenames - including extensions - are in column 1 and new filenames in column 2.

eg:

i1.jpg, i1-lamp
i2.jpg, i2-door knob

If you have Excel then open your csv file and...

C1 =A1&".jpg"
D1 =A1&"-"&B1

Select cells C1 & D1 and copy down to the end of the worksheet
Select columns C & D
Copy and Paste Special to the same columns as Values
Delete columns A & B
Save as csv
Close Excel

Start ARen

Filename: Browse for csv file
Base folder for original files: Just as it says
Column separator: Comma
Click Import

List method should now be set up ready to run the batch

Select Apply to: Name
Start batch

QED


04/02-19 21:16 - edited 04/02-19 21:22