drz73366 2009-08-01 05:47
浏览 44
已采纳

如何在php中使用不同的行终止进行读取?

I'm trying to read a CSV file generated by M$ Excel on linux.

The file has quoted multi-line (x0A separated) columns and a 0x0d0a line termination.

PHP on Linux uses 0x0a as line terminator, so all the line-based tools (file, fgets, fgetcsv) thinks there are record breaks in the middle of the data cells.

Short of processing the file byte by byte, can I temporarily change PHP's end of line character (PHP_EOL constant) so I can easily parse the file.

I think it can be done in perl with "$\". Is there something similar in PHP?

I realize I can parse byte by byte, but I'm looking for a cleaner approach.

  • 写回答

2条回答 默认 最新

  • dst67283 2009-08-01 13:48
    关注

    If conceptDawg's suggestion of auto_detect_line_endings doesn't work, I would recommending reading in the entire file via file_get_contents() and then calling explode() to break up the file into multiple lines. You can pass whatever character you want to explode()

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 我的代码无法在vc++中运行呀,错误很多
  • ¥50 求一个win系统下运行的可自动抓取arm64架构deb安装包和其依赖包的软件。
  • ¥60 fail to initialize keyboard hotkeys through kernel.0000000000
  • ¥30 ppOCRLabel导出识别结果失败
  • ¥15 Centos7 / PETGEM
  • ¥15 csmar数据进行spss描述性统计分析
  • ¥15 各位请问平行检验趋势图这样要怎么调整?说标准差差异太大了
  • ¥15 delphi webbrowser组件网页下拉菜单自动选择问题
  • ¥15 wpf界面一直接收PLC给过来的信号,导致UI界面操作起来会卡顿
  • ¥15 init i2c:2 freq:100000[MAIXPY]: find ov2640[MAIXPY]: find ov sensor是main文件哪里有问题吗