How do I extract $value without the $ sign into a new field?

AlYap

Hi,

I am trying to extract the numbers only from a field of strings. Example below:

Project Total- $463.2MM. Approved

RT:$134.0MM but current pending review.

Approved total - $198,336,058, routed for PO.

Expected output:

463.2

134.0

198.3

Is there a way I can do this based on the variability of some numbers shown in MM, and some in the full value? Otherwise can someone help how I can just extract the value after the "$" sign? Any help welcome.

Regex

Parse

Accepted answers

Qiu

@AlYap

I tried with RegEx and hope this is what you need.

New Workflow1N.yxmd

All comments

Qiu

@AlYap

I tried with RegEx and hope this is what you need.

New Workflow1N.yxmd

mpennington

My formula was a bit different, but I got it to work as well. Probably should have wrapped this in a Tonumber, as @Qiu did.

IIF(REGEX_Match([Field1], '.*\$(\d+),(\d)\d+,.*'), REGEX_Replace([Field1], '.*\$(\d+),(\d)\d+,.*', '$1\.$2'), REGEX_Replace([Field1], ".*\$(\d+\.\d)MM.*", "$1"))

Edit: Couldn't help myself, here is the Tonumber formula:

TONUMBER(IIF(REGEX_Match([Field1], '.*\$(\d+),(\d)\d+,.*'), REGEX_Replace([Field1], '.*\$(\d+),(\d)\d+,.*', '$1\.$2'), REGEX_Replace([Field1], ".*\$(\d+\.\d)MM.*", "$1")))

Match.yxmd

AlYap

Wow. Thank you so much @Qiu. This works!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703