So my first post here. I'm looking for a way to take a list of file names (one file name per line) and compare it to the contents of a few directories.
What's happening is at work we store files in directories like: //server/project/filetype/batch number/file.pdf
However the database will export a .txt file containing all the files that SHOULD be in the directories. Here's the catch not all of the file names from the database reside in the same batch number location. I need to know how to substitute the "number" part of the directory above with a variable the user inputs. I also need to know if a file is not in the directory that should be. OR if a file is in the directory and not the list. And lastly not all files from the list will be in each directory but all files should be accounted for at the end of ALL directories.