当列值本身包含逗号时，以逗号分隔的CSV文件进行爆炸

Question

I am reading a comma deliminated CSV file line by line and then separate each column value using PHP explode function. The problem is that there are some columns which itself have comma (,) values in it so they are also exploded.

A row of data:

03,1392,06,1000,1,"1000,36,21,68",4,AF,TJ,AF,44071000

Here "1000,36,21,68" must be considered as a single value but PHP explode also breaks it. I know this is how explode works but is there any alternate function which can be used in this case. Also i would need to remove the double quotes (") from both sides from this value.

Answer 1

Don't try using explode and parsing it yourself:

use PHP's built-in str_getcsv() function

or use fgetcsv() to read and parse each line directly from file

EDIT

If you're feeling really adventurous, you can use SPL to read and parse the file

$file = new SplFileObject("data.csv");
while (!$file->eof()) {
    var_dump($file->fgetcsv());
}

or

$file = new SplFileObject("data.csv");
$file->setFlags(SplFileObject::READ_CSV);
foreach ($file as $fields) {
    var_dump($fields);
}