xcellrodeo
Board Regular
- Joined
- Oct 27, 2008
- Messages
- 206
Hi MrExcel Community
I would like to ask for some help with achieving the following:
BASE INFO: I have a folder with 50-100 PDF documents. Each PDF document has about 10-15 pages with a cover page.
The cover page is the first page.
TASK: Search the first page of each PDF Document to see if it matches any of the 1 to 4 criteria below AND has a date.
Each PDF document cover page will most likely have one of the Criteria 1 to 4 AND a Date.
CRITERIA 1) "Build Survey"
CRITERIA 2) "Build Sample"
CRITERIA 3) "Build Removal"
CRITERIA 4) "Build Qlty"
CRITERIA 5) "Date" followed by the actual date i.e 14 November 2020 Note: This is on every cover page!
RESULT: In Excel Sheet named 'Results', I would like the following results returned for each PDF searched.
Col A = Name of PDF file (i.e File Name)
Col B = Name of the Criteria found (as mentioned above Criteria 1-4)
Col C = 'Date' followed by the actual date in each document on page 1
NOTE: If the search comes across a PDF which does not fulfil all or any of the above criteria, I would like it still listed
in the Excel Sheet 'Results' but with comment added saying 'Not found'
Hope this makes sense.
Thanks so much for your help
PS: Excel vs is 2010
I would like to ask for some help with achieving the following:
BASE INFO: I have a folder with 50-100 PDF documents. Each PDF document has about 10-15 pages with a cover page.
The cover page is the first page.
TASK: Search the first page of each PDF Document to see if it matches any of the 1 to 4 criteria below AND has a date.
Each PDF document cover page will most likely have one of the Criteria 1 to 4 AND a Date.
CRITERIA 1) "Build Survey"
CRITERIA 2) "Build Sample"
CRITERIA 3) "Build Removal"
CRITERIA 4) "Build Qlty"
CRITERIA 5) "Date" followed by the actual date i.e 14 November 2020 Note: This is on every cover page!
RESULT: In Excel Sheet named 'Results', I would like the following results returned for each PDF searched.
Col A = Name of PDF file (i.e File Name)
Col B = Name of the Criteria found (as mentioned above Criteria 1-4)
Col C = 'Date' followed by the actual date in each document on page 1
NOTE: If the search comes across a PDF which does not fulfil all or any of the above criteria, I would like it still listed
in the Excel Sheet 'Results' but with comment added saying 'Not found'
Hope this makes sense.
Thanks so much for your help
PS: Excel vs is 2010