What a quick way to clean up a monetary string

Question

Possible Duplicate:
PHP: unformat money

How to get rid of everything that is not a number or dot, replacing , with . using a light regex?

Examples:

$50.45     = 50.45
USD 50.45  = 50.45
50,45      = 50.45
USD$ 50.45 = 50.45

so the string *can* start with "USD" and/or "$" followed by digits; optionally followed by "," or ".", followed by more digits? — wonk0, Jul 12 '11 at 09:45
@Gordon i'm not looking to translate the currency, The service only takes USD. — CodeOverload, Jul 12 '11 at 09:45
This answer worked like a charm: http://stackoverflow.com/a/19764699/327862 — Mukesh Chapagain, Aug 11 '15 at 04:17

Shef · Accepted Answer · 2015-12-15T22:02:01.997

6

<?php
$money = array(
    '$50.45',
    'USD 50.45',
    '50,45',
    'USD$ 50.45'
);

// remove everything except a digit "0-9", a comma ",", and a dot "."
$money = preg_replace('/[^\d,\.]/', '', $money);

// replace the comma with a dot, in the number format ",12" or ",43"
$money = preg_replace('/,(\d{2})$/', '.$1', $money);

print_r($money);
?>

Output:

Array
(
    [0] => 50.45
    [1] => 50.45
    [2] => 50.45
    [3] => 50.45
)

edited Dec 15 '15 at 22:02

answered Jul 12 '11 at 09:55

Shef

44,808
15
79
90

Thanks but doesn't work for $1,799.00 gives 1.799.00 – malhal Dec 15 '15 at 21:59
@malhal fixed. Should work fine now. :) – Shef Dec 15 '15 at 22:03

score 1 · Answer 2 · answered Jul 12 '11 at 09:49

1

preg_replace('/.*?(\d+)(?:[.,](\d+))?.*/', '\1.\2', $string);

answered Jul 12 '11 at 09:49

Artefacto

96,375
17
202
225

Thanks, but `USD 54` returns `1.2` – CodeOverload Jul 12 '11 at 09:53
@David You must be using a special version of PHP. See http://codepad.viper-7.com/YpFKRk – Artefacto Jul 12 '11 at 09:56
2

This puts a decimal point following the number, even if there is nothing following it... perhaps `rtrim(preg_replace('/.*?(\d+)(?:[.,](\d+))?.*/', '\1.\2', $string), '. ');`? – Brendan Bullen Jul 12 '11 at 10:09
@Brendan If that's a problem, you can also convert it to a float and back with `(string)(float) preg...`. – Artefacto Jul 12 '11 at 10:42
Hi @Artefacto - if you have the time, could u explain your regex ? – MarcoZen Dec 07 '18 at 02:38

score 1 · Answer 3 · edited Jun 20 '20 at 09:12

The solution I came up with that works with your examples was:

preg_replace("([^0-9\.])","",str_replace(",",".",$val));

Assuming comma only ever appears when it should be a decimal point, as opposed to being a thousands separator. It replaces those with a decimal place, and then removes all non numeric/decimal characters from the remaining string altogether.

Test script:

$inputs = array("\$50.45", "USD 50.45", "50,45", "USD\$ 50.45");

foreach ($inputs as $val) {
    $cleanVal = preg_replace("([^0-9\.])","",str_replace(",",".",$val));
    echo "GIVEN: <b>".$val."</b> -> CLEAN: <b>".$cleanVal."</b><br/>";    
}

Output:

GIVEN: $50.45 -> CLEAN: 50.45

GIVEN: USD 50.45 -> CLEAN: 50.45

GIVEN: 50,45 -> CLEAN: 50.45

GIVEN: USD$ 50.45 -> CLEAN: 50.45

Doesn't work, try $5,000.45 it gives 5.000.45 – malhal Dec 15 '15 at 22:02 — malhal, Dec 15 '15 at 22:02

score 0 · Answer 4 · edited May 23 '17 at 12:18

This would work too for the given examples (demo):

$money = array(
    '$50.45',
    'USD 50.45',
    '50,45',
    'USD$ 50.45'
);

foreach ($money as $val) {
    echo filter_var(
        str_replace(',', '.', $val),
        FILTER_SANITIZE_NUMBER_FLOAT,
        FILTER_FLAG_ALLOW_FRACTION
    ), PHP_EOL;
}

// gives 
// 50.45
// 50.45
// 50.45
// 50.45

This will fail when the string contains fractions and thousand separators. There is a filter flag FILTER_FLAG_ALLOW_THOUSAND that could potentially handle thousand separators as well. But since the thousand separators can indicate fraction in other locales and you want to take it into account, it wont work in your scenario.

For a more powerful parsing alternative try

numfmt_parse_currency - Parse a string into a double and a currency using the NumberFormatter.

A simple example can be found in PHP: unformat money. The example code in the accepted answer will only parse $50.45 though. The NumberFormatter can be configured with additional rules, so while I am not 100% certain, I think it should be possible with it.

thousand separator support is really needed in any web-based solution, I voted you down sorry. — malhal, Dec 15 '15 at 22:03
@malhal Yes, I explicitly state that the code snippet won't work with a thousand separator. And I offer two possible workarounds. Have you tried those? — Gordon, Dec 16 '15 at 11:08

What a quick way to clean up a monetary string

4 Answers4

Linked