|Welcome to the Monastery|
Re: Extracting string from a fileby RMGir (Prior)
|on Nov 11, 2013 at 13:02 UTC||Need Help??|
As it stands, I don't think your code even compiles, since you've got an unbalanced '(' in your regular expression. I'd start by fixing that.
Second, '|' is a special character in regular expressions, meaning "this OR that". Since you want a literal '|', you need to precede it with a '\'.
Next, you're using '|' again between TOTAL and your digits, while your example has spaces there. Which is it?
Finally, you're only capturing the first number, and you said you need both.
Putting all of that together, please try this regular expression:
I think that might work better for you....