Skip to main content
jmcg2222
Participant
Feb 28, 2020 4:08 PM UTC
Question

Way to Automate a Merge/Text Fileld Extraction from Multiple PDFS

So a bit new to Acrobat. I have a ton of proposal PDFs I have to go through and pull out specific fields - and searching for some way to automate the process insteacd of opening each one and searching for the field and then copy and paste to word or excel.

 

So say I have people that filled out Fillable-Proposal.pdf and sent it in. On each .pdf I need to delete the first and last pages and merge them into one giant .pdf.

 

Is it also possible to somehow have something that finds Text_FieldA for each pdf and exports that text somewhere?

Ugh - this is why you have people fill this stuff out online! That way you have a database you can pull from!!!

This topic is closed to new replies. Start a new post to keep the conversation going.

2 replies

Thom Parker
Community Expert
Thom ParkerCommunity Expert
Community Expert
Feb 29, 2020 6:50 PM UTC

It is also possible to use an Action (batch process) script to collect all the data into a single list and then generate an attached csv file or text file. 

Translate
Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
try67
Community Expert
try67Community Expert
Community Expert
Feb 28, 2020 4:13 PM UTC

You can use the Merge Data Files into Spreadsheet command in Acrobat to export all the data from all of the files to a single spreadsheet. Then open it in Excel and delete all the columns, except for the one you're interested in.

Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices