Printable View
I have 64,000 JPEG images of sheetmusic in a directory, and I want to pull approximately 18,000 of them out [All of the Vocal ones]. I have a list of the filenames that I want to keep. How do I get my pc to do this filter without me having to move them by hand?
Your response is greatly apppreciated.
Aaron Buckley
[email protected]
What are the file names? If they are regular and consistent, it should be a piece of cake:).
Put the file names that you want to keep in an array...
Use this array in a loop with FindFirstFile & FindNextFile....MoveFile to put the good files in another folder..then use FindFirstFile & FindNextFile again in the original folder, but use wildcards (*.*).....for each file call DeleteFile on all remaining files in the folder...then RemoveDirectory to finish the job
The file names are in an access database right now, and are mostly 8 digit numbers like this:
50428991
50428220
50428221
50428300
etc...
Then the image files are all named that number .JPG like this:
50428991.JPG
50428993.JPG
50428994.JPG
50428999.JPG
50428210.JPG
50428215.JPG
50428220.JPG
50428221.JPG
50428250.JPG
50428251.JPG
50428300.JPG
etc...
Yeah, but what is the difference between the ones you want and the ones you don't want?
The ones that I want to keep are the ones that match up to all of the items in our database.
It is for a vocal sheet music website. I've got a database of 64,000 Hal Leonard sheet music books, and a directory with 64,000 images. I've got the database pared down to just the 18,000 Vocal titles, and it is ready to be loaded onto our website. The problem is that I can't load all 64,000 images without smashing through my account's total disk space of just 300MB. If I could pare them down to just the 18,000 Vocal ones that I need, then I could let the web browsing public search our database with images matched up to every item.
If I have all of the extra images, then it will take up 821MB of server space, verses 230MB of space if I remove the ones that we aren't using.
Well, I'm no expert on file operations, but if I was, I would obtain a directory listing in the form of an array, and one by one sort through the list, checking each item against your database. If there is a match, move the item to another directory, and delete the item from both the array and the database (create a temporary database).