Rename photos by CSV columns and rows

[xSHONKYx]

Good morning,

I have photos that were exported with an excel file. The photos names are a Photo ID number which are also in a row that link up to a string of data within the excel file. I'm trying to get the renaming tool to find the match the photos name to the name within the excel sheet and CONCAT 2 rows of data to form a new name.

An example being file name 00e115ed-58d8-44cf-9ff4-1ed98b65350c.jpg, finding it within row DF of the excel file, and using the data within column S for a block name, and between column T to AZ for the row name (if blank then move on to next column until data is found for name), then CONCAT that into a new name being B4 R55. The data only has a number to the "B" and "R" will need to be added before the CONCAT data.

I hope that this explains what I'm after and I hope there is a way of doing this easily enough.

Thank you,

Dan

[therube]

(Without really following your post, & without knowing Excel) sounds like the Rename Pairs feature is what you'll need, viewtopic.php?p=13843#p13843.

The CONCAT part I'd think you'd have to set that up in Excel in a new column.
So for instance:
Col A would be the name as it exists on disk
Col B would be a CONCAT of S + T..AZ, the new name as you want it
& then use A & B as your source for the Rename Pairs

(Again, not really following the Excel end of things...)