Efficient way of removing extraneous zeros from prices?

Question

I have prices stored to five decimal places of precision, such as:

When displaying prices, I'd like to show the standard $X.XX format if the rest of the digits are just zero, but if there are significant digits then I don't want to cut them out (so I can't simply use number_format()).

As an example, the above prices should display as:

This process has to be done on hundreds of prices per page. What's an efficient way of formatting numbers in this manner?

@Chandresh Doesn't keep two decimal places of precision when the digits to the right of the decimal point are 0's. Ex echo (float)'2.00' results in 2. — Nate
– Nate, Commented Dec 5, 2014 at 4:45
Have you referred this one?-stackoverflow.com/questions/14531679/… — Chandresh M
– Chandresh M, Commented Dec 5, 2014 at 4:51

FuzzyTree · Accepted Answer · 2014-12-06 01:09:51Z

3

This uses a regex to match everything before the trailing 0s

$i = "$1.00";
$pattern = '/\$(\d+)\.(\d\d)(0*)/';
$replacement = '\$$1.$2';
print preg_replace($pattern,$replacement,$i);

Another way using rtrim on everything after the first 2 digits right of the decimal

$pos = strpos($i, '.') + 3;
print substr($i, 0, $pos) . rtrim(substr($i, $pos), '0');

edited Dec 6, 2014 at 1:09

answered Dec 5, 2014 at 4:53

FuzzyTree

32.4k3 gold badges58 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Nate Over a year ago

I almost started trying to write a regex for this, then thought to myself "no.. there has to be a better way!"

sjagr Over a year ago

@Nate I don't think there is, since you're looking for two explicit parameters: round off 0's + preserve at least 2 decimal places. You either check each separately or regex. EDIT: Hot damn

sjagr Over a year ago

How about substr($i, 0, strpos($i, '.') + 2) . rtrim(substr($i, strpos($i, '.') + 2), '0') for a one-liner? You could take the strpos into another variable though to lower execution time.

FuzzyTree Over a year ago

@sjagr agreed, that's a faster way

sjagr · Accepted Answer · 2015-01-06 15:30:22Z

2

This is kind of ugly but it does the job:

function formatPrice($price) {
    $out = (float)$price; // Trim off right-hand 0's
    $out = "$out"; // Typecast back to string
    if ((strlen($out) - strpos($out, '.')) <= 2) { // Test for string length after decimal point
        $out = number_format($out, 2); // Format back with 0's
    }
    return $out;
}

Testing it now... Works!

Here's a one-liner function from my other comment thanks to @FuzzyTree's answer:

function formatPrice($price) {
    return substr($price, 0, strpos($price, '.') + 3) . rtrim(substr($price, strpos($price, '.') + 3), '0');
}

edited Jan 6, 2015 at 15:30

answered Dec 5, 2014 at 4:49

sjagr

16.6k5 gold badges43 silver badges69 bronze badges

2 Comments

Nate Over a year ago

Would you want to update your answer with the comment you left on the other answer? Your one-liner works, although I had to change the + 2 to + 3.

sjagr Over a year ago

@Nate Sure, done! However I had already added my comment to that answer

Collectives™ on Stack Overflow

Efficient way of removing extraneous zeros from prices?

2 Answers 2

4 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related