Extract numbers from string using regex in powershell

lokeshsharma7 · 2018-10-16T12:48:57.000Z

Extract all the numbers from string and output their SUM. I’m struggling to achieve same using REGEX in powershell

String ='“Total Facility A Commitments” means the aggregate of the Facility A Commitments, being £2,500,000 at the date of this Agreement.
“Total Facility B Commitments” means the aggregate of the Facility B Commitments, being £2,500,000 at the date of this Agreement.
“Total Facility C Commitments” means the aggregate of the Facility C Commitments, being £2,500,000 at the date of this Agreement.
[“Total Incremental Facility Commitments” means, in relation to an Incremental Facility, the aggregate of the Incremental Facility Commitments relating to that Incremental Facility.] ’
Output = £7,500,000

Neally · 2018-10-16T13:05:25.000Z

You said you are struggeling, what have you tried so far?

Please share your code so we can help.

You can use the ‘-match’ operator and then look for numbers in the string.

If you post code, please use the insert code button! Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

Evan7191 · 2018-10-16T14:08:17.000Z

You can use the following RegEx to match the numbers with commas and currency symbol:

[\D\W][\d,?]+

Evan7191 · 2018-10-17T12:50:56.000Z

This worked for me:

$string = get-content text.txt
$string = $string -ireplace '.*(?<Value>£(\d+,?)+).*','${Value}' -match '£'
($string -ireplace '£|,','' | Measure-Object -Sum).Sum.ToString("C")

Output: $7,500,000.00

The output shows dollars ($) based on my OS culture info. If necessary, you can adjust the OS culture with Set-Culture.