Hi all
This may be a bit of a long shot but I wondered if anyone had any ideas on how to do the process someone has asked me to look into…
Step 1 - see if words from a list of words appears in a PDF document
Step 2 - if it does, either
- A) grabs the page number of the page it appears on then carries on searching through the document
or - B) grabs the whole sentence it appears in (this may not be the best of the two options in case something important is missed in the next sentence)
Step 3 - enter the information obtained (page number or sentence) in an Excel table
e.g. - if the word was “Contractor”, it would find it and write back to Excel that the word was found on page number 10:
The document will be anywhere from 50 to 300 pages, they’ll be sent from different companies so there’s no set template, the word may or may not appear in a table (as shown above).
I can manage step 1 and 3 but I have no idea with step 2. Any ideas please?
Thanks