Mapping jpeg name to excel database

Closed
smd_excel Posts 27 Registration date Saturday April 18, 2009 Status Member Last seen November 22, 2012 - Dec 15, 2009 at 12:09 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 17, 2010 at 05:58 AM
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,
Related:

2 responses

nagina
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 17, 2010 at 05:58 AM
What if a pic is sames Joe and you have Joe Hoe and Joe Doe
0