How to find multiple files within a folder by title

TL;DR

I have a folder with thousands of jpg files, and I’m trying to find a way to search for a couple hundred of them at a time and migrate those images into a separate folder.


Here’s the situation: I work in E-commerce and just used a FTP transfer to download an entire company’s image catalog. All of the jpg files are titled as the product’s sku number. I also have an excel sheet with roughly 200 of these skus that I need to find the corresponding image for. Essentially I’m looking for a way to use the list of sku numbers I have in excel to do some sort of “vlookup” within the image folder and only return those results. This would look something like: “search” 123-1,456-1,789-1 “return” 123-1.jpg,456-1.jpg,789-1.jpg.


Is is there a way to do this within finder or within console? If not, is there any known extensions that might be able to do this type of search?

Posted on Jul 20, 2019 11:46 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to find multiple files within a folder by title

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.