Mapping jpeg name to excel database

Closed
Report
Posts
27
Registration date
Saturday April 18, 2009
Status
Member
Last seen
November 22, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I've got a folder with a number of jpeg pictures each named after employee names. i need to rename with full names (First Middle Last Name) by lookin up an excel database which holds this data.

the picture names are either named with a combination of first name only, or first name second name or second name only.

i need to take the picture name and search it through the excel database which has 3 columns holding 1st, middle and last name and then rename the picture with the name from excel.

any help wud be much appreicated.

thanks,

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What if a pic is sames Joe and you have Joe Hoe and Joe Doe