Forum Discussion
Syndicate_Admin
2 years agoAdministrator
Power Query - Extracting Data from a PDF
I have a PDF document, lets say 100 pages for example, where 50 pages contain information I want to extract into excel format. The information i want is the client name and their address. The pos...
Einomi
2 years agoHelper V
I believe PQ is one of the best tool to extract info from a PDF. Please can you share some screenshots from your query ?
- Syndicate_Admin2 years agoAdministrator
I've attached an example of a PDF I am working with. I've removed some text but highlighted in yellow to indicate there was text there previously. I'd like to create a to pick up the beneficiary name, TFN and the input for the tax items e.g. A, A1, A2 etc.