Help with Regex Statement

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?

Regex

Accepted answers

Thanks for sharing the inputs as requested.

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

.+\s(.+)$

Many thanks

Shanker V

Help with Regex Statement.yxmd

All comments

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.

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

Alteryx Grand Totals Excel SS.xlsx

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

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

Parse workflow grand totals.yxmd

This worked perfectly. Thank you so very much!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15879

MarqueeCrew 13708

apathetichell 13703