I’m not sure Automator can do this, I have searched the forums and several of the Automator tutorial websites but haven’t found quite what I need.
What I want to do is take one text file (or it could be an Excel file, I don’t care) with a list of words to Find in a folder full of files (around 300 files).
For example say I have this list in a txt file:
Big Dog
Furry Cat
Bird
Fox
I would want the action to search every document for every occurrence of ‘Big Dog’, then search for every occurrence of ‘Furry Cat’, etc. I would also want to replace each instance with something else, say a formatted html link specific to each word (i.e. ‘Big Dog’ would become a html link to a product page about ‘Big Dog’ etc).
So in other words I have one reference document with a list of words/phrases to search/replace against a folder full of documents.
Is something like that even possible with Automator? I am on a MBP/Snow Leopard. If Automator won’t do it does anyone know of any applications that specialize in this type of advanced Find/Replace? Thanks in advance for any help/advice.
Model: MacBook Pro 2.8 GHz Core 2 Duo
Browser: Safari 533.16
Operating System: Mac OS X (10.6)