Pulling Data from Large PDF to Xlsx

[MrBaker89]

Afternoon all, 

 

I've got a 1114 page PDF that is a mixture of parts diagrams and text. 

 

I'm trying to extract the information but when I try and import the data through excel it kills my ram 32GB DDR4 3200mhz. 

 

Is there a way to discard the pages with pictures on without going through them one by one? 

 

Or is there a program I can use that is better than importing from excel?

 

TIA 

[OddOod]

I was unaware you *could* import from PDF to XL

what data are you trying to pull? Is regex a possibility?

[MrBaker89]

2 minutes ago, OddOod said:

I was unaware you *could* import from PDF to XL

what data are you trying to pull? Is regex a possibility?

Yep you can. 

 

It's an automotive parts PDF. Screenshot below of what it contains. 

 

Trying to pull just the text from the part number column. 

 

[jaslion]

Split the pdf in sections.

 

Try 100 pages at a time (course stop at logical intervals).

 

What are you using for this?

Adobe acrobat? If so 100 pages is ABSOLUTLY the max.

 

[MrBaker89]

1 minute ago, jaslion said:

Split the pdf in sections.

 

Try 100 pages at a time (course stop at logical intervals).

 

What are you using for this?

Adobe acrobat? If so 100 pages is ABSOLUTELY the max.

 

Tried 50 pages with acrobat and the program kept crashing. 

 

I was thinking of splitting the PDF into multiple PDF files and then using the Excel data import function. 

[jaslion]

1 minute ago, MrBaker89 said:

Tried 50 pages with acrobat and the program kept crashing. 

 

I was thinking of splitting the PDF into multiple PDF files and then using the Excel data import function. 

Oh if you are doing excel try it with a 10page sample, set the rules up and let it rip

[MrBaker89]

1 minute ago, jaslion said:

Oh if you are doing excel try it with a 10page sample, set the rules up and let it rip

Rules? Sounds like I'm missing something here lol 

[jaslion]

15 minutes ago, MrBaker89 said:

Tried 50 pages with acrobat and the program kept crashing. 

 

I was thinking of splitting the PDF into multiple PDF files and then using the Excel data import function. 

Oh if you are doing excel try it with a 10page sample, set the rules up and let it rip

[jaslion]

17 minutes ago, MrBaker89 said:

Rules? Sounds like I'm missing something here lol 

The dataload in excel is with powerquery.

 

You can define a ton of rules it needs to follow if need be. Like only fetch data if column x appears and such

[MrBaker89]

3 minutes ago, jaslion said:

The dataload in excel is with powerquery.

 

You can define a ton of rules it needs to follow if need be. Like only fetch data if column x appears and such

I'll do some research on rules. Thank you.