preg_match on price

dr4296

Greetings All!

Say, I have the following statement that's suppossed to do a match on a price:

preg_match("/\d+.\d{2}/", $price_found[1],$parsed_price);

However, if the string that we're reading has a comma in it (example: $1,455.37), the preg_match reads only the stuff after the comma ($455.37).

I get totally confused by regular expression matching. Every time I think I grasp it, I encounter something that throws me off. How can I adjust the above line so that, if the string DOES have a comma (and realize that it may not), it pulls out the entire price (ignoring the comma itself)?

Thanks !!!

-= Dave =-

mrmufin

This appears to work a little better than yours...

$str = "$1,444.50";
if(preg_match("/[\\d+|\\d+,\\d+]\\.\\d{0,2}/",$str)) {
        echo "<br />$str<br />";
}

dr4296

Originally posted by mrmufin
This appears to work a little better than yours...
$str = "$1,444.50";
if(preg_match("/[\\d+|\\d+,\\d+]\\.\\d{0,2}/",$str)) {
        echo "<br />$str<br />";
}
[/B]

Just tried:

preg_match("/[d+|d+,d+].d{0,2}/", $price_found[1], $parsed_price);

echo "parsed_price[0]= $parsed_price[0]<BR>";

Fed it several numbers.

In each case, I got back the comma, followed by a single digit.

-= Dave =-

dr4296

My apologies.

Somehow some slashes got left out of my cut-and-paste, it seems.

Now using:

preg_match("/[\d+|\d+,\d+]\.\d{0,2}/", $price_found[1], $parsed_price);

And what I get out now for $parsed_price[0] is a single digit, the decimal point, and two zeroes:

5.00
9.00
6.00
etc...

Thanks!

-= Dave =-

dr4296

Well, now I've got it to the point where it pulls out the entire number, INCLUDING the comma.

I discovered this by adding a "+" after the bracketed character class.:

preg_match("/[\d+|\d+,\d+]+.\d{0,2}/", $price_found[1], $parsed_price);

Now I just have to figure out how to get it to dump that comma, so that it will store the match as an integer and not a string.

-= Dave =-

mrmufin

preg_replace("/,/","",$str)

dr4296

Originally posted by mrmufin
preg_replace("/,/","",$str)

Yeah, that's what I just now ended up doing, though I think it's kind of a cheesy way to do it.

Thanks for your help!!

-= Dave =-

Mega

sorry if sum1 has posted this:

preg_match('#(\$[0-9,.]+[0-9]+)#', '\\\\1',$parsed_price);

Weedpacket

Originally posted by dr4296

Yeah, that's what I just now ended up doing, though I think it's kind of a cheesy way to do it.

No; it's perfectly respectable to use two statements to perform two separate tasks 🙂

$price=str_replace(',','',$price);

would be faster - and if you do that before the preg_match you woudn't have to worry there about commas at all.