Regular expression for CSV files

August 22nd, 2006PHP Administrator

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′);

1 Comment

Comments RSS TrackBack Identifier URI

Leave a comment

Name (required)

Mail (will not be published) (required)

Website

Your comment