Compare folder and filename

[sidsmot]

Hi,

I have a column of filenames I wish to compare to a column of folder names, both full paths.

Folderlist is format "c:\test\AAA - 2008 - BBB" - constant in folder name is - YEAR -
Filename is format "c:\AAA - BBB.jpg"

Can anyone help with code to match AAA & BBB?

If returns true, I want to move file into the folder by using

Name "c:\AAA - BBB.jpg" As "c:\test\AAA - 2008 - BBB\AAA - BBB.jpg"

How can I trim c:\ off the filename so it can be added to folder name for renaming as above?

Thanks

 

[sidsmot]

Sorted it by using text to columns in macro.