Unformat money when parsing in PHP

by

This is a bit more complex/ slow solution, but works with all locales. @rlenom’s solution work only with dots as decimal separator, and some locales, like Spanish, use the comma as decimal separator.

<?php

public function getAmount($money)
{
    $cleanString = preg_replace('/([^0-9\.,])/i', '', $money);
    $onlyNumbersString = preg_replace('/([^0-9])/i', '', $money);

    $separatorsCountToBeErased = strlen($cleanString) - strlen($onlyNumbersString) - 1;

    $stringWithCommaOrDot = preg_replace('/([,\.])/', '', $cleanString, $separatorsCountToBeErased);
    $removedThousandSeparator = preg_replace('/(\.|,)(?=[0-9]{3,}$)/', '',  $stringWithCommaOrDot);

    return (float) str_replace(',', '.', $removedThousandSeparator);
}

Tests:

['1,10 USD', 1.10],
['1 000 000.00', 1000000.0],
['$1 000 000.21', 1000000.21],
['£1.10', 1.10],
['$123 456 789', 123456789.0],
['$123,456,789.12', 123456789.12],
['$123 456 789,12', 123456789.12],
['1.10', 1.1],
[',,,,.10', .1],
['1.000', 1000.0],
['1,000', 1000.0]

Caveats:
Fails if the decimal part have more than two digits.

This is an implementation from this library:
https://github.com/mcuadros/currency-detector

More Related Contents:

  1. Converting a number with comma as decimal point to float
  2. Prevent PHP parsing in strings [closed]
  3. PHP parse/syntax errors; and how to solve them
  4. PHP – Floating Number Precision [duplicate]
  5. parse youtube video id using preg_match [duplicate]
  6. Parsing Huge XML Files in PHP
  7. Convert dot syntax like “this.that.other” to multi-dimensional array in PHP
  8. Transform relative path into absolute URL using PHP
  9. PHP HTML DOMDocument getElementById problems
  10. Best way to process large XML in PHP [duplicate]
  11. PHP unexpected result of float to int type cast
  12. Preg match text in php between html tags
  13. Selecting a float in MySQL
  14. Parsing HTML files as PHP
  15. PHP YAML Parsers [closed]
  16. Parsing URL query in PHP [duplicate]
  17. How to parse fixed width column text in php?
  18. Simplify PHP DOM XML parsing – how?
  19. PHP: Best way to extract text within parenthesis?
  20. Any decent PHP parser written in PHP? [closed]
  21. PHP – parse current URL
  22. What is a good parser generator for php?
  23. Comparing floats – same number, but does not equal? [duplicate]
  24. How to display Currency in Indian Numbering Format in PHP?
  25. checking if a number is float in PHP
  26. json parse error with double quotes
  27. Extract floating point numbers from a delimited string in PHP
  28. PHP DOMDocument getting Attribute of Tag
  29. Programmatically access currency exchange rates [closed]
  30. Code to parse user agent string?

Leave a Comment