Parse CSV file which contains a new line to php array

Question

I have a CSV file with:

Test1,One line
Test2,"Two lines

Hello"
Test3,One line

As you can see, one of the columns has a value which is separated with a new line.

To parse this CSV file into an array, I run:

$csvArray = array();
$csvData = file_get_contents('file.csv');
$lines = explode(PHP_EOL, $csvData);
foreach ($lines as $line) {
    $csvArray[] = str_getcsv($line);
}
// print_r($csvArray);

It works beside one problem. It reads the new line in the value as a new row, which is completely incorrect.

How do I make it so that it properly reads a multi-line value?

Edit: this question focuses on new lines.

Possible duplicate of How to parse a CSV file using PHP

k0pernikus
– k0pernikus

2017-05-26 12:44:28 +00:00
Commented May 26, 2017 at 12:44 — k0pernikus
– k0pernikus, Commented May 26, 2017 at 12:44

k0pernikus · Accepted Answer · 2017-05-26 12:43:36Z

16

$fp = fopen('filecsv', 'r');

$csvArray = array();

while ($row = fgetcsv($fp)) {
    $csvArray[] = $row;
}

fclose($fp);

Using explode(PHP_EOL, $csvData) will not correctly split the CSV by its row delimitor. The multi line cell is encapsulated with quotations meaning the row will continue onto new lines until they are closed.

PHP's built in fgetcsv function will correctly read a single row from a file, moving the pointer to the next row in the process. While str_getcsv will only read a single row from a string without considering additional rows (because its a string, not a stream).

Since you have already split the string with explode, your CSV row is broken, so the row will be incomplete.

edited May 26, 2017 at 12:43

k0pernikus

67.6k78 gold badges245 silver badges366 bronze badges

answered May 26, 2017 at 12:33

Flosculus

6,9563 gold badges22 silver badges44 bronze badges

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

2 Comments

Henrik Petterson Over a year ago

Could you please elaborate on your answer?

Henrik Petterson Over a year ago

Fantastic, thank you very much for this. You are totally correct!

Collectives™ on Stack Overflow

Parse CSV file which contains a new line to php array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related