note 107620 modified in function.str-getcsv by danbrown

[A previous version of this function which I wrote] did not parse empty cells at the end of a line correctly. Here's the fixed version. Thanks to Graham Lawrence for the fix.
<?php
 function parse_csv($file,$comma=',',$quote='"',$newline="\\n")
 {
 $db_quote = $quote . $quote;
 
 // Clean up file
 $file = trim($file);
 $file = str_replace("\\r\\n",$newline,$file);
 
 $file = str_replace($db_quote,'"',$file); // replace double quotes with " HTML entities
 $file = str_replace(',",',',,',$file); // handle ,"", empty cells correctly
						$file = str_replace(","\\n",",\\n",$file); // handle ,""\\n empty cells correctly at the end of lines
 
 $file .= $comma; // Put a comma on the end, so we parse last cell 
 
 
 $inquotes = false;
 $start_point = 0;
 $row = 0;
 $cellNo = 0;
 
 for($i=0; $i<strlen($file); $i++) {
 
 $char = $file[$i];
 if ($char == $quote) {
 if ($inquotes) {
 $inquotes = false;
 }
 else { 
 $inquotes = true;
 }
 } 
 
 if (($char == $comma or $char == $newline) and !$inquotes) {
 $cell = substr($file,$start_point,$i-$start_point);
 $cell = str_replace($quote,'',$cell); // Remove delimiter quotes
 $cell = str_replace('"',$quote,$cell); // Add in data quotes
 if ($row>0) $data[$row][$data[0][$cellNo]] = $cell;
 else $data[$row][] = $cell;
 $cellNo++;
 $start_point = $i + 1;
 if ($char == $newline) {
 $cellNo = 0;
 $row ++;
 }
 }
 }
 return $data;
 }
?> --was-- The previous function did not parse empty cells at the end of a line correctly. Here\'s the fixed version. Thanks to Graham Lawrence for the fix. <?php function parse_csv($file,$comma=',',$quote='"',$newline="\n") { $db_quote = $quote . $quote; // Clean up file $file = trim($file); $file = str_replace("\r\n",$newline,$file); $file = str_replace($db_quote,'"',$file); // replace double quotes with " HTML entities $file = str_replace(',",',',,',$file); // handle ,"", empty cells correctly $file = str_replace(","\n",",\n",$file); // handle ,""\n empty cells correctly at the end of lines $file .= $comma; // Put a comma on the end, so we parse last cell $inquotes = false; $start_point = 0; $row = 0; $cellNo = 0; for($i=0; $i<strlen($file); $i++) { $char = $file[$i]; if ($char == $quote) { if ($inquotes) { $inquotes = false; } else { $inquotes = true; } } if (($char == $comma or $char == $newline) and !$inquotes) { $cell = substr($file,$start_point,$i-$start_point); $cell = str_replace($quote,'',$cell); // Remove delimiter quotes $cell = str_replace('"',$quote,$cell); // Add in data quotes if ($row>0) $data[$row][$data[0][$cellNo]] = $cell; else $data[$row][] = $cell; $cellNo++; $start_point = $i + 1; if ($char == $newline) { $cellNo = 0; $row ++; } } } return $data; } http://php.net/manual/en/function.str-getcsv.php