Extracting Text from PDF and finding the Keywords

Like (1) Share

Report

Posted on 9 May 2025 16:46:32 by SN-09051636-0

Hi,

I am extracting text from pdf and searching for 50 keywords which are Transaction 1, Transaction 2 up to Transaction 50. After extraction, I am passing each keyword(Transaction1) and searching for keyword to extract the pdf pages and creating sub pdf files depending on the keyword. I ran in to an issue where, Transaction 1 is being detected from Transaction 11 and Transaction 2 is being detected when I pass Transaction 21, Transaction 22 etc.

As these items are dynamic, I cannot use Parse Text. I tried using text boundaries - "\\b" & %CurrentItem% & "\\b" on a variable and passing this value to Parse Text action to get the result but the variable is just appending \\b to the text.

Please let me know how to achieve this.

Thanks in advance!

Categories:

Process Advisor

PAD Error.png

All responses (3)

Answers (0)

stampcoin 4,012 Super User 2025 Season 2 on 09 May 2025 at 20:43:29

Like (0)

Report
Extracting Text from PDF and finding the Keywords

@SN-09051636-0 Hi,

I assume that currentItem is integer/Number

if currentItem =1 , target = \bTransaction\s+1(?!\d)

\b is a word boundary to ensure "Transaction" isn’t part of a larger word.

\s+ matches the space (or any whitespace) after "Transaction" (allows for one or more spaces if formatting is inconsistent).

1 (N)is the current number (e.g. 1, 2, 11, etc., inserted dynamically).

(?!\d) is a negative lookahead that ensures the number N is not followed by another digit. This prevents partial matches like "1" within "11".

could you please try: Set variable RegexPattern = "\\bTransaction\\s+" & %CurrentItem% & "(?!\\d)"
SN-09051636-0 2 on 09 May 2025 at 19:02:28

Like (0)

Report

Extracting Text from PDF and finding the Keywords

Hi @stampcoin,

Thank you for responding. Here my current item is Transaction 1, Transaction 2 etc. I have tried your solution but it is appending '& "\b to my variable and after parsing using Parse text, its not finding the match. Here is the screenshot for the variable value.

I have a list of Transactions and for each transaction, I am extracting the pdf file pages.

Thanks!
stampcoin 4,012 Super User 2025 Season 2 on 09 May 2025 at 18:23:11

Like (0)

Report

Extracting Text from PDF and finding the Keywords

@SN-09051636-0 Hi,

You can try this pattern ( you may want to change it a little as your need)

Set variable RegexPattern to "\bTransaction\s+" & 'CurrentItem'& "\b"
or
Set variable RegexPattern to "Transaction\s+" & 'CurrentItem' & "(?!\d)"

good luck.