How to get rid of the dollar sign?

Question

Ok, so I am importing csv through the PHP script that I am writing, and the spreadsheet has values ​​like $ 4090.00, and I need to paste these values ​​into the mysql decimal field using PHP. Is there an easy way to get rid of $ if it is present in PHP

Answer 1

With str_replace or even cropping:

$str = str_replace('$', '', $str);
$str = trim($str, '$'); // only delete $ at start or end of the string

There are many solutions for this. Also note that you should use the period separator for decimal and integer parts, not a comma.

Answer 2

$value = "$4090,00";
$value = preg_replace('/[\$,]/', '', $value);

Answer 3

, str_replace :

$nodollars = str_replace('$', '', $some_string);

Answer 4

sscanf, .