Help with Regex Statement

[hyost]

Good evening. I am using the following Regex expression that a contractor built for me to help pull out the grand totals for some pdfs that I extracted. However, it is not pulling all of the Grand Totals. I cannot use the contractor anymore, so I could really use some help. I don't know the first thing about this. Thank you in advance!

.*\*{3}\s\QGrand Totals:\E.*\d*\s\d*\s\d*\s(\d*\,?\d*\.\d\d\-?)

Goal: Grab the last set of numbers for each one. For some reason it is only grabbing the 142.00 and the 1,801.65. I need it to grab the 1,859,675.73 and 27,142,097.56 as well. How do I modify the expression to do this? 

[ShankerV]

Hi @hyost 

We could use better regex condition to read the last numbers.

Could you please copy and paste the input in excel file, will be helpful to tweak the Regex in better form.

[hyost]

Thank you very much for responding. Is this what you are looking for? I apologize, but I'm very new to this.

[DataNath]

Hey @hyost, there's a few ways you could go about this but here's one way if the format is consistent.

.*\s([^\s]+).*

[ShankerV · Accepted solution]

Hi @hyost 

Thanks for sharing the inputs as requested.

One way of doing this with simple regex statement is as below.

.+\s(.+)$

Many thanks

Shanker V

[hyost]

This worked perfectly. Thank you so very much!