从csv文件中删除“$”

I have a php page that takes in a csv file and uploads it to my database. The issue I am having is that some of the fields have a '$' which i do not need. Is there a way to remove the $ from only some of the fields?

Data structure

COLL_ID   COCC_ID   AGEDTOTAL    PAYMENTTOTAL    
5074      11110     $7.50        ($7.50)

my Query

$deleterecords = "TRUNCATE TABLE mytable"; //empty the table of its     current records
mysql_query($deleterecords);

//Upload File
if (isset($_POST['submit'])) {
    $i=0;
    if (is_uploaded_file($_FILES['filename']['tmp_name'])) {
    echo "<h1>" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "</h1>";
    echo "<h2>Displaying contents:</h2>";
    readfile($_FILES['filename']['tmp_name']);
}

//Import uploaded file to Database
$handle = fopen($_FILES['filename']['tmp_name'], "r");

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    if ($i>0){
    $import="INSERT into mytable(COLL_ID, COCC_ID, AGEDTOTAL, PAYMENTTOTAL) values('$data[0]','$data[1]','$data[2]','$data[3]')";

    mysql_query($import) or die(mysql_error());
}
$i++;
}

For the whole file

$string = preg_replace(
    '/((:?.*?\,){2}.*?)\$/',
    '$1',
    $string
);

2 is a ((Number of column that contains $ symbol) - 1)

or

$data[2] = str_replace('$', '', $data[2]);