Regular expression for CSV files
Posted: August 22nd, 2006 | Author: Administrator | Filed under: PHP | 1 Comment »After many hours of searching, I found this regular expression to work the best on parsing CSV files:
$expr = “/,(?=(?:[^\"]*\”[^\"]*\”)*(?![^\"]*\”))/”;
Example:
$matches = preg_split($expr, ’2006-01-01, “Apples, Oranges, and Pears”, $5.95′);
Thanks! That worked perfectly