Breaking News: Grepper is joining You.com. Read the official announcement!

doble quotes in csv export php

Indian Gooner answered on August 17, 2021 Popularity 3/10 Helpfulness 4/10

answer doble quotes in csv export php

doble quotes in csv export php

Comment

fputs($fp, implode(",", array_map("encodeFunc", $row))."\r\n");



/***
 * @param $value array
 * @return string array values enclosed in quotes every time.
 */
function encodeFunc($value) {
    ///remove any ESCAPED double quotes within string.
    $value = str_replace('\\"','"',$value);
    //then force escape these same double quotes And Any UNESCAPED Ones.
    $value = str_replace('"','\"',$value);
    //force wrap value in quotes and return
    return '"'.$value.'"';
}

$fp = fopen("filename.csv", 'w');
foreach($table as $row){
    fputs($fp, implode(",", array_map("encodeFunc", $row))."\r\n");
}
fclose($fp);

Popularity 3/10 Helpfulness 4/10 Language php

Source: stackoverflow.com

Tags: csv export php quotes

Link to this answer
Share Copy Link