/* Takes string converts to 2d array and returns known values - html (26/02/08)*/
function parseCSV($csv) {
    // convert string to array by newline
    $csv = explode("\n", $csv);
    // now that we have the array we need to split based on ,
    $csvn = array();
    foreach ($csv as $c) {
        // remove any dud lines
        if (!preg_match('/^\b+$/', $c) && $c != '') {
            $temp = explode(",", $c);
            $count = sizeof($temp); $empty =0;
            $wrong = false;
            for($i=0;$i<=$count;$i++) {
                $nquotes = substr_count($temp[$i], '"');
                if ($nquotes %2 == 1) {
                    for ($j = $i+1; $j < count($temp); $j++) {
                        if (substr_count($temp[$j], '"') > 0) {
                            // Put the quoted string's pieces back together again
                            array_splice($temp, $i, $j-$i+1,
                                implode($separator, array_slice($temp, $i, $j-$i+1)));
                            break;
                        }
                    }
                }
                if ($nquotes > 0) {
                    // Remove first and last quotes, then merge pairs of quotes
                    $qstr =& $temp[$i];
                    $qstr = substr_replace($qstr, '', strpos($qstr, '"'), 1);
                    $qstr = substr_replace($qstr, '', strrpos($qstr, '"'), 1);
                    $qstr = str_replace('""', '"', $qstr);
                }
                if ($temp[$i] == '' || preg_match('/^\b+$/', $temp[$i])) {
                    $empty++;
                }
                if ($empty >= $count/2 || stristr($temp[$i],'Merchandiser') || stristr($temp[$i], '"Cash and Carry') || stristr($temp[$i], 'Motorway Service Areas') || stristr($temp[$i],'"Forecourts')) { $wrong = true; }
            }
            if ($wrong == false) $csvn[] = explode(",", $c);
        }
    }
    
    // now that we have our array we need to name the fields
    return $csvn;
}