Closed Thread
Results 1 to 2 of 2

Power Query Code to Extract Discontinuous Tables from PDF

  1. #1
    Registered User
    Join Date
    03-12-2014
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    52

    Power Query Code to Extract Discontinuous Tables from PDF

    I need help with a Power Query code that can loop through multiple PDFs in a folder and extract the tables in red font as shown in the sample PDF into Excel format as shown. Each PDF has a date on the top. I want to grab the date shown and fill it in a column as shown in the sample result. Different PDFs have different dates but the table formats are pretty similar.

    In the PDFS, I only care about the tables in the red font (I used red here to differentiate the table that I need from other tables). I may have multiple tables before it as shown in the sample PDF, but I want to discard those tables. My main table of interest always appears as the last table in the document and always starts with ?Type? and ends with ?Comment?

    The main issue I have is that the table in the red font have breaks in them but I still want to grab all the data in red and the headers do not span across the page. There is no specific pattern on how these breaks occur.
    Thank you for your anticipated help.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,970

    Re: Power Query Code to Extract Discontinuous Tables from PDF

    Closed - OP has opened a thread in Commercial Services instead.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Query: Appending Tables
    By andrewc in forum Excel General
    Replies: 4
    Last Post: 08-26-2021, 09:48 AM
  2. [SOLVED] Combine tables in Power Query
    By Ebl in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 08-02-2021, 08:11 AM
  3. [SOLVED] Power Query Extract
    By AllisterB in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-17-2021, 05:49 PM
  4. Replies: 8
    Last Post: 10-21-2020, 03:02 AM
  5. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  6. Power Query: Updating a query based on changing tables
    By cheesehead101 in forum Excel General
    Replies: 1
    Last Post: 12-16-2019, 06:54 PM
  7. Power Query tables in VBA
    By orhanceliloglu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2018, 08:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1