I'm hoping someone can help me write a rule.
I have a few thousand project folders that have comments on them consisting of a contact's name and project number. For instance, one folder might be called "Hamburger Flyer 05.05.16" and have a comment of "Bob 3-1111".
Inside that folder are the project files – usually an Adobe InDesign file (Hamburger Flyer.indd), some .jpgs (DSC_0001.jpg and DSC_0012.jpg), and a .pdf (Hamburger Flyer.pdf).
On that .pdf somewhere is a text box with that same project number (3-1111) all by itself.
What I would like to do is to copy each .pdf (again, I have thousands) to a designated folder, and append the project number to the file name. So, for instance, I'd like to copy Hamburger Flyer.pdf to a new folder I've created called "Finals" and change the name of the .pdf to either "Bob 3-1111 Hamburger Flyer.pdf" or "3-1111 Hamburger Flyer". (I don't care which...the project number is the important part.) So, I can grab the project number either from the enclosing folder or from the content of the .pdf.
I'd like to be able to set this rule up so that it goes inside of all containing folders (2016 > May > Hamburger Flyer 05.05.16) so I don't have to do each folder individually. For the life of me, I can't figure out just how to get this to work. Any pointers?