extracting text preceding duplicate search term results

New Here ,
Mar 27, 2018

Copy link to clipboard

Copied

working on tax deductions i am attempting to extract the dollar amount (which precedes the common search term atm withdrawal) in my pdf bank statements

I'm essentially trying to filter all of my atm withdrawals from store purchases.

able to search the term (ATM withdrawal) and export that to csv/xlsx however it would be great to extract the info before or after my search term.

can anyone assist?

Most Valuable Participant
Correct answer by try67 | Most Valuable Participant

Actually, I just thought of another option, which doesn't involve a script, but will require some post-processing.

You can use the Advanced Search command in Acrobat to look for this term and then export the results to a CSV file.

The resulting file will contain the immediately context of each result, which should include the numbers you're looking for.

However, it will also include a bunch of other stuff which you're probably not very interested in...

TOPICS
Acrobat SDK and JavaScript

Views

170

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

extracting text preceding duplicate search term results

New Here ,
Mar 27, 2018

Copy link to clipboard

Copied

working on tax deductions i am attempting to extract the dollar amount (which precedes the common search term atm withdrawal) in my pdf bank statements

I'm essentially trying to filter all of my atm withdrawals from store purchases.

able to search the term (ATM withdrawal) and export that to csv/xlsx however it would be great to extract the info before or after my search term.

can anyone assist?

Most Valuable Participant
Correct answer by try67 | Most Valuable Participant

Actually, I just thought of another option, which doesn't involve a script, but will require some post-processing.

You can use the Advanced Search command in Acrobat to look for this term and then export the results to a CSV file.

The resulting file will contain the immediately context of each result, which should include the numbers you're looking for.

However, it will also include a bunch of other stuff which you're probably not very interested in...

TOPICS
Acrobat SDK and JavaScript

Views

171

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 27, 2018 0
Most Valuable Participant ,
Apr 09, 2018

Copy link to clipboard

Copied

This would require a custom-made script.

I can think of two ways of doing it: A straight-forward search of the file for the phrase "ATM withdrawal" and then extracting the text before it, or using the "Search & Remove Text" command under an Action to highlight all of these terms and then a separate script to extract the numeric text preceding them. The latter would require some additional steps but is much more robust and will be able to handle longer and more complex files. It does require Acrobat Pro, though.

If you're interested in either solution feel free to contact me privately (try6767 at gmail.com) to discuss it further. I've developed various similar tools in the past for my clients, so it should not be a problem.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 09, 2018 0
Most Valuable Participant ,
Apr 09, 2018

Copy link to clipboard

Copied

Actually, I just thought of another option, which doesn't involve a script, but will require some post-processing.

You can use the Advanced Search command in Acrobat to look for this term and then export the results to a CSV file.

The resulting file will contain the immediately context of each result, which should include the numbers you're looking for.

However, it will also include a bunch of other stuff which you're probably not very interested in...

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 09, 2018 0