Hi all, I need a regex pattern that will work with an excel cell which will have different invoice amount values. Excel cell value + Pattern will go into a folder of differnent PDF’s then try match the value in the pdf.

Sample:

Excel value will always be changing

excel cell value - 1236

Expected Output:

Match all these possible outcomes of Invoice total amount format structures:

-1923.00

-1,923.00

-$1923

The Pattern:

I found this pattern which is able to highlight the amount regardless of format - \d+(.\d+)?

Each pdf displays the invoice total amount in different, just attempting to make sure the cell value and total amount value in the Invoice match.

Any help will be appreciated, Thank You