search for a list of files

I'm confused a bit by your terminology. I think the answer is simple and I could try to guess what you're asking but by "name" do you mean "filename"? What do you mean by "list"?

 

????
Multiple files
Filenames are all numeric
Located in different folders
Want to find several files and move them to another folder

If I've got that right, then, yeah: one at a time

 

A Smart Folder search can probably do this. You'd have to add the numbers from the list one at a time.

https://support.apple.com/kb/PH25484?viewlocale=en_US&locale=en_US

You can get more complex search criteria by holding down the OPTION key, the (+) button will change its label, then click it, and you then have an "Any"/"All" popup. If you know boolean logic, "Any" is OR, and "All is AND.

https://support.apple.com/kb/PH25589?locale=en_US

If a Smart Folder search isn't good enough, maybe look on the Mac App Store for apps that perform complex searches and file-finding actions.

 

So you want to compare the entries in the text file to file names in a directory. You could use a simple chain of commands in Terminal, e.g.

Code:

find PATH | grep -f LIST.txt

or:

Code:

while read file; do find PATH -name $file; done < LIST.txt

Replace PATH with the directory and LIST.txt with your text file. The first one lists all files in the directory and prints those that are on the list, whereas the second will look for matching file names for each line in the file.

This will not work with Excel though and it presupposes that each file name is on a separate line. You can also so pattern matching; there is a lot more you can do with Terminal commands.

 

This idea can be taken further, by putting the entire process into an Automator workflow.

For example, the Automator workflow can tell Excel to open a file and export a particular column as text (an AppleScript step), then the text file can be passed along to a Run Shell Script step that contains a script like you've shown. The output from that can be passed along to subsequent Automator steps. If the output of the Run Shell Script is a list of Posix-style pathnames, then that can be used as input for a Move or Duplicate step.

In any case, the OP will need to post a more detailed description, and possibly provide sample data. At this point, it's a programming task, and although Automator offers a high-level view of such things, the individual steps will need shell scripting, with specific details filled in and then tested by the OP.

I also suggest changing $file in the example script to "*$file*", as the request is for the number in the filename, not as the filename. However, I could be misinterpreting what the OP is asking for. Details are important in programming.