Need a guru

[lsk2002]

Not a FM question, just thought someone might know how to do this....

I have a table in Microsoft Access that has obsoleted part numbers. I want to delete the same parts from a folder of images. Is there a way to do this? There are about 1100 of them and I really don't want to search through 4000 photos for each of them one by one...

Thanks,

ls

[Wiedenmaier]

Hi,

One option could be:

• create a query, which selects all obsolete parts
• create a macro, which writes a batch-file to disc (i.e. deleteparts.bat)
• for each row in query's result write one line to the batch file like this

del path/filename.ext

for possible parameters of del process open your DOS Box and call "del /?"

Make sure you've got a backup of your parts folder(s).

Another possibility is to do delete process in your macro directly.

Bye

Markus

[Michael_Müller-Hillebrand]

Isk,

put the part numbers in a text file, then use the features of a text editor to add prefixes and suffixes to create a batch file, which you can use from the Windows Console to delete the files. If the image file names follow a strict scheme this should be no problem.

This is really, really off-topic and I should not have answered it 😉

- Michael

[lsk2002]

Well, thanks for answering anyway. I had looked all over on the internet, not really finding anything. I probably was just searching wrong. Sorry for the non FM question...:)