need to convert text amount so I can get a sum and an average

[jmurch]

I have a value that as is cannot be manipulated arithmatically.

 

The values are in the format '$x,xxx.xx'.  Is there a built in PHP function to strip out the $ and the ',' so I can treat this as a integer?

[Goldeneye]

You could just use str_replace, like so:

 

<?php
$text = str_replace('$', '', $text);
$text = str_replace(',' '', $text);
?>

[jmurch]

Thanks Goldeneye.

[Caesar]

Or preg_replace...

 

<?php

$str = '$1,500.00';
$a = array('/\$/','/,/');
$B = array('','');

$number = preg_replace($a,$b,$str) * 2;

echo $number;

?>