Spliting CSV (comma seperated) entry grouped by double quotes

By using fgetcsv function we can have well formatted output for csv data without any pain. If you don’t want to use fgetcsv function for some reason and your CSV comma separated entries may contain comma inside except the delimiters, here is a quick alternate.

For example we have two rows in our CSV file as below:

DiabetesStore.Com,9833263, www.DiabetesStore.Com,0.0,0.0,0,0,0,1,0,0.0,0.0,0.0,0.0
"Expedia, Inc",10514985,USA - 88x31 - Expedia Logo,0.0,0.0,0,0,0,3,0,0.0,0.0,0.0,0.0

Here is a piece of regular expression which performs it well:

$string="\"Expedia, Inc\", 10514985, USA - 88x31 - Expedia Logo, 0.0, 0.0, 0, 0, 0,3,0,0.0, 0.0, 0.0, 0.0";
$data = preg_split( "/[,]*\\\"([^\\\"]+)\\\"[,]*|[,]+/", $string, 0, PREG_SPLIT_DELIM_CAPTURE|PREG_SPLIT_NO_EMPTY);

PREG_SPLIT_DELIM_CAPTURE captures the parenthesized (within “(” and “)” ) content within the string while PREG_SPLIT_NO_EMPTY removes the empty array elements which are supposed to be created by splitting the string by very first occurrence (or the last occurrence sometimes).

I hope this helps someone!

2 thoughts on “Spliting CSV (comma seperated) entry grouped by double quotes

  1. Thank you, your code done the job for me.

    I was using this http://www.sitepoint.com/forums/php-34/preg_split-regex-csv-type-line-commas-except-if-quotes-168638.html before I came across your solution.

    Much obliged.

  2. Good Stuff!

    Alternately, one can use use this smart preg chunk of code found at php.net which takes care of strings starting with quoted values as stated by you.

    function csv_string_to_array($str){
    $expr=”/,(?=(?:[^\”]*\”[^\”]*\”)*(?![^\”]*\”))/”;
    $results=preg_split($expr,trim($str));
    return preg_replace(“/^\”(.*)\”$/”,”$1″,$results);
    }

Leave a Reply

Your email address will not be published. Required fields are marked *