Comparing files in a windows directory

[mlabac]

Anyone no how to compare a list of image files in a windows directory to a list of image names in my db? Also, if those image names do not exist in the windows directory I need to delete them from the directory.

Thanks

 

[PHV]

What have you so far ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[mlabac]

I have nothing at all, not sure were to start.

 

[fumei]

Does your db exist already?

Gerry

 

[mlabac]

Yes, my DB already exists. Basically what I need to do is remove any special characters (i.e. #, &, *, etc.) in the image name in my db. Got that taken care of. When I remove the characters, the image name will not match the file name in the windows directory. I need to be able to rename those file names to the new image name in the db. I am thinking there is probably an API call that will help out with this.

 

[PHV]

Something like this ?
Name oldpathname As newpathname
In your object browser, take a look at [/b]FileSystem[/b]

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884