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?