fputcsv with tab delimiter

php delimiter fputcsv
Stefan picture Stefan · Nov 7, 2014 · Viewed 7.7k times · Source

I would like to create a CSV document with a tab delimiter. I've tried a lot of things and searched all over the internet but there isn't a single site with a working solutions. This is the script I'm using right now, but it is exporting without a tab delimiter

    $data[] = array("item 1", "item 2");
    $data[] = array("item 3", "item 4");
    $export = fopen("/export/test.csv", "w");
    foreach ($data as $row) {
      fputcsv($export, $row, "\t");
    }
    fclose($export);

I've also tried different other things instead of \t like chr(9) but nothing worked. Any solutions for this problem?

Answer

NealVDV picture NealVDV · May 31, 2016

Was searching for a solution to the same problem. Saw the solution in the comments by Mark Baker

Use fwrite($export, "sep=\t".PHP_EOL); before writing any contents to the file.

Related questions

How do I explode an integer

the answer to this could be easy. But I'm very fresh to programming. So be gentle... I'm at work trying to do a quick fix for one of your customers. I want to get the total numbers of digits in …

Read More
If you explode a string and said string does not contain the delimiter, does explode kick an error?

So I'm getting a section of the url with php. This section may or may not have trailing '?' values. So for example : I'm exploding the url : stackoverflow.com/questions and I want to get questions so i do …

Read More
How to explode a string, with spaces and new lines?

I would like to explode a string (separated based on a delimiter and placed into an array), using both a space (" ") and a newline ("\n") as a delimiter. The method (which I don't think is the best way) is to: …

Read More