remove a character

[Anon]

Hi,

I have a field that takes a cost, the problem is some people instead of just adding say 4.50 or 34.50 whatever the cost is, they also add the $ sign. This then returns in the database as 0 cos it's not an int.

I was wondering how I could strip this $ sign off or anyother non int for taht matter.

Thankyou.

[vsego]

The most loose would be:
$out = ereg_replace("[^.[:digit]]", "", $in);
This will remove all chars except for digits and dot(s).

You might consider doing this:
if (ereg("^{[.[:digit]]([[:digit:]](.[[:digit:]])).$",} "\1", $in, $reOut))
$out = (double)$reOut[1];
This will strip all non-(digit or dot)s from the begining, then capture the number (integer or double) then strip the rest (from first non-digit to end). Then it will return what's left and cast it to double.
Also, this version allows only one decimal point.

[Anon]

Thankyou, the number is actually a 4,2 float. I'll test with your suggestions, thankyou

[vsego]

4,2 float? Then
if (ereg("^{[.[:digit]]([[:digit:]]{4}.[[:digit:]]{2}).$",} "\1", $in, $reOut))

Btw, my previous post had a little bug:
if (ereg("^{[.[:digit]]([[:digit:]](.[[:digit:]])?).$",} "\1", $in, $reOut))
"?" was missing (in case number was integer and not double).

You can also add:
else
$out = (double)$in; (or report error - else is when there is no 4,2 float in input string)