Participant

Question

VBA or JavaScript to perform a text search 2,000+ times

Forum|Forum|8 years ago
July 24, 2017
2 replies
990 views

Hi experts,

I need to search several PDFs containing a total of 40,000 pages for 2,000 account numbers.

Can this be automated using VBA or JavaScript or other?

Which do you recommend and why?

Thank you,

Peter

Acrobat SDK and JavaScript

This topic has been closed for replies.

Bernd Alheit

Community Expert

What should be the result of the search?

P

P JohnstonAuthor

Participant

When using the Advanced Search feature, Acrobat returns the number of documents, number of instances and the name of documents that the search text was located in.

Bernd Alheit

Community Expert

You want make a screenshot for every account number?

try67

Community Expert

JavaScript: Out of the question. Acrobat can't handle that amount of information. I'm guessing the same applies for VBA as well.

I have developed a stand-alone application, written in Java, that can do it. If you're interested in such a tool feel free to contact me privately (try6767 at gmail.com) to discuss it further.

P

P JohnstonAuthor

Participant

I have used the Acrobat "Full Text Index and Catalog" feature that allows me to create an index for my 40,000 pages. Then using AutoIt, a keyboard & mouse replication tool, I read an account from Excel into the clipboard. Then, using the advanced search feature in Acrobat, I am able to search the index for that account. Adobe performs the search in about 1 second so this part is sufficient. That part that is painfully slow is how I read the account numbers from Excel.

Is it possible to access the advanced search feature within Acrobat using VBA or JavaScript? I'm a developer and have used VBA before; in the process of learning JavaScript; and haven't worked with Java in quite a while so would rather not go down that path but appreciate your offer.

Thanks,

Pete

lrosenth

Adobe Employee

No, it is not.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded