Converting a number with comma as decimal point to float

Question

I have a list of prices with a comma for a decimal point and a dot as the thousand separator    Some examples   12 30 116 10 1 563 14  These come in this format from a third party  I want to convert them to floats and add them together   What is the best way to do this  number format doesn t seem to work with this format  and str replace seems like overkill  as I have to do it more that once on each number   Is there are better way  Thanks

User · Answer

Might look excessive but will convert any given format no mater the locale:

function normalizeDecimal($val, int $precision = 4): string
{
    $input = str_replace(' ', '', $val);
    $number = str_replace(',', '.', $input);
    if (strpos($number, '.')) {
        $groups = explode('.', str_replace(',', '.', $number));
        $lastGroup = array_pop($groups);
        $number = implode('', $groups) . '.' . $lastGroup;
    }
    return bcadd($number, 0, $precision);
}

Output:

.12           -> 0.1200
123           -> 123.0000
123.91        -> 12345678.9100
123 456 78.91 -> 12345678.9100
123,456,78.91 -> 12345678.9100
123.456.78,91 -> 12345678.9100
123 456 78,91 -> 12345678.9100

User · Answer

Assuming they are in a file or array just do the replace as a batch  i e  on all at once     input   str replace array            array            input      and then process the numbers from there taking full advantage of PHP s loosely typed nature

User · Answer

This function is compatible for numbers with dots or commas as decimals  function floatvalue  val                val   str replace          val                val   preg replace                      val               return floatval  val       This works for all kind of inputs  American or european style   echo floatvalue  1 325 125 54       The output is 1325125 54 echo floatvalue  1 325 125 54       The output is 1325125 54 echo floatvalue  59 95              The output is 59 95 echo floatvalue  12 000 30          The output is 12000 30 echo floatvalue  12 000 30          The output is 12000 30

User · Answer

You could use the NumberFormatter class with its parse method

User · Answer

Using str replace   to remove the dots is not overkill    string number    1 512 523 55      NOTE  You don t really have to use floatval   here  it s just to prove that it s a legitimate float value   number   floatval str replace           str replace           string number         At this point   number is a  natural  float  print  number     This is almost certainly the least CPU-intensive way you can do this  and odds are that even if you use some fancy function to do it  that this is what it does under the hood

User · Answer

from PHP manual      str replace     Replace all occurrences   of the search string with the   replacement string    I would go down that route  and then convert from string to float - floatval

User · Answer

If you re using PHP5 3 or above  you can use numfmt parse to do  a reversed number format   If you re not  you stuck with replacing the occurrances with preg replace str replace

[php] Converting a number with comma as decimal point to float

Examples related to php

Examples related to parsing

Examples related to floating-point