Moving files from folder based on the excel data

Hello,

I need help in coding this task please.

I have a column in a excel file with the image of products, like this:

COLUMN D
0600-01BK_D.jpg
0600-06BK_D.jpg
0600-77BK_D.jpg
0770-10TC_D.jpg
0770-15BK_D.jpg
0770-77BK_D.jpg
0800-10BK_D.jpg
1000-27BK_D-1.jpg
1015-03SL_D.jpg

I also have a folder of images where are located the images of the products listed in the excel file. Some products have more than one image, for example, the first product on the excel file have the following 3 images:

0600-01BK_D.jpg
0600-01WH_D-1.jpg
0600-01PK_D-2.jpg

Other products may only have 1 image, and the folder also contains images not indicated on the xls file.

I need to move to another folder all the images for each product listed on the excel file, based on the criteria of first characters. I need this criteria be variable; some listing is based on the first 4 characters, others on the first 5 characters, the example explained here use 7 characters. Finally, the files were not found, I need highlight in the excel file.

Could anyone help me on this please?

Thanks in advance!!!

Hello JBeaucaire,

I have enclosed a sample of excel file, a list of files on image folder and examples of how the images are named.

The criteria has to be variable because I have several group of images. In the example I posted, the first 7 characters are the same for all images, however, I have group of images where only the first 4 characters are the same, other group has the first 5 characters the same, etc, etc.

Thanks!

You are right, I'm sorry for that. The product 0011-12 exist on the excel file so the images for this item should be moved. It should read this way:

product image on excel file for item 0011-12:
0011-12GY_D-3.jpg
images for folder:
0011-12GY_D-1.jpg
0011-12GY_D-2.jpg
Because the product is in the excel file, all images for this product will go to the new folder

Your suggestion is good about using the item number, I can use this column, however, it must be with minimum of 4 characters because I have other listing with only 4 characters identical.

Thanks!

Hi JBeaucaire,

I looked at the file names and no, there is no chance that could happen. With a minimum of 4 characters the move will be safe, even with a minimum of 3, most groups of images are ok.

Thanks!

JBeaucaire,

I appreciate your help. I tested the code on 5 groups of images with different number of characters and it worked 100%. No one single false match found.

Thank you!!!