doudi7782 2018-11-23 21:05
浏览 205
已采纳

使用str_getcsv进行CSV解析在新行上失败

While reading a csv file with PHP a problem occured with a line break within the CSV file. The contents of one cell will be split once a comma is followed by a line break:

$csv = array_map('str_getcsv', file($file));

first,second,"third,
    more,text","forth"
next,dataset

This will result in:

1) first | second | third
2) more text | forth
3) next | dataset

While it should result in:

1) first | second | third more text | forth
2) next | dataset

Is this a bug within str_getcsv?

  • 写回答

1条回答 默认 最新

  • dongse5528 2018-11-23 21:55
    关注

    Don't do that, use fgetcsv(). You're having problems because file() doesn't care about the string encapsulation in your file.

    $fh = fopen('file.csv', 'r');
    
    while( $line = fgetcsv($fh) ) {
        // do a thing
    }
    
    fclose($fh);
    

    https://secure.php.net/manual/en/function.fgetcsv.php

    And try not to store all the lines into an array before performing your operations if you can help it. Your system's memory usage will thank you.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 maccms影视模板 制作影视网站失败 求
  • ¥15 stm32按键设置闹钟数进退位不正常
  • ¥15 三电平逆变器中点电位平衡问题
  • ¥20 这怎么写啊 java课设
  • ¥15 用C语言完成一个复杂的游戏
  • ¥15 如何批量更改很多个文件夹里的文件名中包含文件夹名?
  • ¥50 MTK手机模拟HID鼠标出现卡顿
  • ¥20 求下下面这个数据结构代码
  • ¥20 前端 二进制文件流图片转化异常
  • ¥15 github上的这个C语言项目如何跑起来