Skip to main content
J
jmcg2222
Participant
February 28, 2020
Question

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

  • February 28, 2020
  • 2 replies
  • 328 views

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 has been closed for replies.

2 replies

Thom Parker
Community Expert
Thom ParkerCommunity Expert
Community Expert
February 29, 2020

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. 

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
try67
Community Expert
try67Community Expert
Community Expert
February 28, 2020

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.

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