For data-mining purposes I am looking for a possibility to script an action which does more or less the following on a bunch of text-based files (either PDF with text or rtf):
repeat with every file inside the group of selected files:
- search through a bunch of text-based files (either PDF with text or rtf) for specific keywords (e.g. invoice date, invoice amount, value-date received)
- copy the adjacent text around those matched keywords (e.g. the next 50 characters)
- paste the selection into a specified excel file in cell A1
- select the next row same column in Excel
As my scripting abilities are not really advanced I ask myself if anyone has done something similar before…
Many thanks for your help in advance.