Adding line breaks in a csv file

Question

I got a coma separated string. I need to convert this to an array and be able to save it as a csv file.

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

$data = str_getcsv($str);
fputcsv($fp, $data);
fclose($fp);

Currently it outputs the entire string as a single line.

Expected csv output:

FRUIT,       STOCKS,      TYPE
lychee,      instocks,    B-type
strawberry,  N/A,         A-type

Answer 1

You have two delimiters (newline and comma), so you want to run the function twice. Though as Jay pointed out, you may not need the foreach since it's already comma separated.

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

Answer 2

For your exact string you would need to do this:

file_put_contents('abc.csv', "FRUIT, STOCKS, TYPE\n lychee, instocks, B-type\n strawberry, N/A,A-type\n");

The reason that your current code is failing is because the fputcsv() function is taking your values and double-quoting them as necessary.

Open your CSV file with a text editor and not a spreadsheet viewer and you will see what I am talking about.

Answer 3

You can first of all use the break line delimiter to separate each row and then, using the comma delimited to separate each value of your column as you can see at the example.

Is very important to use the double quote in the break line delimiter ("\n") when you use any php function.

I recommend use the trim function to delete white spaces.

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

$data = str_getcsv($str,"\n");

foreach($data as $line){
    fputcsv($fp, str_getcsv($trim($line)));
}

fclose($fp);

Regards!

Answer 4

Try

$fp = fopen("abc.csv", "w");
$array= array("FRUIT,STOCKS,TYPE","lychee,instocks,B-type","strawberry, N/A,A-type"); 
foreach ($array as $row) {               
    fwrite($fp, $row . "\r\n");
}
fclose($fp);