oreo haven
Board Regular
- Joined
- May 15, 2008
- Messages
- 65
All,
I have a problem where several invoices may have the wrong information written into them. As long as the number in Column B is inside the PDF listed in Column A, I know that it is ok.
So I would like to search the file listed in column A and see if the strin listed in the corresponding row in Column B is found in it. If so, I just need a "True" to be written to the corresponding Cell in Column C.
I have 3800 invoices to check, right now. Depending on the results, I could end up with 30k more files to check.
I do have Acrobat Pro and have enabled the libraries.
Has anyone here run into this before? The table below is what I would prefer to have in the end.
I have a problem where several invoices may have the wrong information written into them. As long as the number in Column B is inside the PDF listed in Column A, I know that it is ok.
So I would like to search the file listed in column A and see if the strin listed in the corresponding row in Column B is found in it. If so, I just need a "True" to be written to the corresponding Cell in Column C.
I have 3800 invoices to check, right now. Depending on the results, I could end up with 30k more files to check.
I do have Acrobat Pro and have enabled the libraries.
Has anyone here run into this before? The table below is what I would prefer to have in the end.
| STRING_TO_FIND | Is_It_There | ||||||
---|---|---|---|---|---|---|---|---|
c:\users\jsd\documents\invoices\18996_58720_INV767056.pdf | 767056 | TRUE | ||||||
c:\users\jsd\documents\invoices\18996_58728_INV767057.pdf | 767057 | TRUE | ||||||
c:\users\jsd\documents\invoices\18996_58736_INV767058.pdf | 767058 | TRUE | ||||||
c:\users\jsd\documents\invoices\18996_58744_INV767059.pdf | 767059 | FALSE | ||||||
c:\users\jsd\documents\invoices\18996_58752_INV767060.pdf | 767060 | TRUE | ||||||
c:\users\jsd\documents\invoices\18996_58760_INV767065.pdf | 767065 | TRUE | ||||||
c:\users\jsd\documents\invoices\18996_58768_INV767066.pdf | 767066 | FALSE | ||||||
c:\users\jsd\documents\invoices\18996_58776_INV767067.pdf | 767067 | FALSE | ||||||
c:\users\jsd\documents\invoices\18996_58784_INV767069.pdf | 767069 | TRUE |