We help IT Professionals succeed at work.
Get Started

Can I query a windows folder to select a specific list of files in search results?

itsquad
itsquad asked
on
129 Views
Last Modified: 2018-02-15
I have 26,000 pictures in one folder called "Images".  Each picture contains each product's item code in it.  I'd like to query the Windows folder "Images" to give results of a pre-determined list of item codes - say that are in a referring table.  Is this possible?  Of course the query would have to use a wild-card search...
example:
Item Code = 081124555435
Picture Name = 081124555435xactual.jpg

So I'll need to pull batches of around a 100 pictures for many different product types many times - all with different item codes.

Of course I can do one by one with a copy paste, but I'm almost 50 now and I feel I may not have that much time left on the planet!  :D

Update: I actually have the exact name of the file I want for each item.  
Here's a sample list of those:
IMAGEORIG
683274011097xactual.jpg
761294017814xactual.jpg
761294015193xactual.jpg
761294012857xactual.jpg
761294008522xactual.jpg
761294008508xactual.jpg
749699161806xactual.jpg
717669414139xactual.jpg
691991202186xactual.jpg
691991201400xactual.jpg
691991201370xactual.jpg
691991200496xactual.jpg
52252274xactual.jpg
683274011158xactual.jpg
761294020937xactual.jpg
683274011066xactual.jpg
52201113xactual.jpg
683274010939xactual.jpg
683274010786xactual.jpg
683274010755xactual.jpg
683274010731xactual.jpg
683274010618xactual.jpg
683274010595xactual.jpg
683274010496xactual.jpg
683274010137xactual.jpg
614252064309xactual.jpg
606559309184xactual.jpg
691991200465xactual.jpg
761294081440xactual.jpg
4959112057647xactual.jpg
52200200xactual.jpg
5226933xactual.jpg
06300194xactual.jpg
800315032952xactual.jpg
761294500071xactual.jpg
761294413302xactual.jpg
761294413296xactual.jpg
761294407127xactual.jpg
761294403570xactual.jpg
761294403563xactual.jpg
761294403556xactual.jpg
761294017838xactual.jpg
761294083840xactual.jpg
761294018293xactual.jpg
761294057520xactual.jpg
761294057513xactual.jpg
761294053041xactual.jpg
761294053034xactual.jpg
52200020xactual.jpg
761294042656xactual.jpg
761294037195xactual.jpg
761294024881xactual.jpg
761294024874xactual.jpg
4957054022846xactual.jpg
761294022818xactual.jpg
4959112057623xactual.jpg
52244116xactual.jpg
Comment
Watch Question
NVITEnd-user support
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 5 Answers and 19 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE