Skip to main content
Inspiring
November 7, 2011
Question

Need a guru

  • November 7, 2011
  • 2 replies
  • 674 views

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

    This topic has been closed for replies.

    2 replies

    Michael_Müller-Hillebrand
    Legend
    November 7, 2011

    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

    lsk2002Author
    Inspiring
    November 7, 2011

    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...:)

    Inspiring
    November 7, 2011

    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