CSV with fputcsv() third parameter

Question

I got a string with semi clones. I want to create a csv file.

$fp = fopen("abc.csv", "w");
$str = "FRUIT; STOCKS; TYPE\n lychee; B-type,A-type; instocks\n strawberry; A-type;N/A\n";

$rows = str_getcsv($str, PHP_EOL);
foreach($rows as $row) {
    $data = str_getcsv($row);
    fputcsv($fp, explode(';',$data), ";");
}

The fputcsv() doesn't seem to work correctly.

When I open the csv using EXCEL the data should be in separate columns where the semi colon (;) was.

FRUIT       TYPE           STOCKS
Lychee      B-type,A-type  instocks
Strawberry  A-type         N/A

EDIT:

My current output and problems are 1. If there's are more than one words those are wrapped by a " (e.g. below)

FRUIT;STOCKS;TYPE;"COST PER ITEM"

The final output is as (when opened in excel).

FRUIT;STOCKS;TYPE;"COST PER ITEM" Lychee "B-type A-type"; instocks; $54; Strawberry; A-type; N/A; $31;

Each ; is in a seperate column. I want the final output to be like this

FRUIT       TYPE           STOCKS    COST PER ITEM
Lychee      B-type,A-type  instocks  $54
Strawberry  A-type         N/A       $31

fputcsv() works perfectly well, what is your actual problem? What result are you getting? — Mark Baker
– Mark Baker, Commented Apr 6, 2016 at 9:16
If there is more than one word in a column, then it should be wrapped in quotes..... that's what the CSV specification says should happen.... this is not_ a problem — Mark Baker
– Mark Baker, Commented Apr 6, 2016 at 9:34
Try to open the csv file in any editor not excel & post the content. — Dipanwita Kundu
– Dipanwita Kundu, Commented Apr 6, 2016 at 9:42

Mark Baker · Accepted Answer · 2016-04-06 09:38:41Z

1

Don't try to use str_getcsv() to parse the whole string into lines, str_getcsv() is designed to parse a single row, not the entire content of a file/string

$str = "FRUIT; STOCKS; TYPE\n lychee; B-type,A-type; instocks\n strawberry; A-type;N/A\n";

$rows = explode("\n", $str);

foreach($rows as $row) {
    $data = str_getcsv($row, ';');
    $data = array_map('trim', $data);
    fputcsv($fp, $data, ';');
}

EDIT

It looks as though your MS Excel may be expecting a comma (,) as separator rather than a semi-colon (;).... so you may need to tell MS Excel this

explicitly write a sep=; line as the first line of your file

fwrite($fp, 'sep=;'.PHP_EOL);

before your data loop

edited Apr 6, 2016 at 9:38

answered Apr 6, 2016 at 9:16

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Becky Over a year ago

Thank you. I tried your suggestion. Output was same as in my original code. Please see my edit.

Collectives™ on Stack Overflow

CSV with fputcsv() third parameter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related