开发者

fgetcsv fails to read line ending in mac formatted csv file, any better solution?

开发者 https://www.devze.com 2023-02-01 15:30 出处:网络
I was parsing a csv file using php with fgetcsv function. It parsed all content in a line, later i found, csv contains carraige return as 开发者_开发知识库\"\\r\". I saw - it was reported as php bug b

I was parsing a csv file using php with fgetcsv function. It parsed all content in a line, later i found, csv contains carraige return as 开发者_开发知识库"\r". I saw - it was reported as php bug before. I've solved this by setting php runtime configuration which is -

ini_set("auto_detect_line_endings", "1");

is there any more solution or is this the right way?

Thanks


Setting auto_detect_line_endings is explicitly recommended by the php documentation.

However, I cannot fathom why you would want to delimit lines with \r in 2010. If possible, convert them to the UNIX-style \n.


\r line endings are created by Microsoft Excel when saving as a CSV file, so there is not much getting around that if you are starting with an Excel spreadsheet.

Using auto_detect_line_endings works fine, or you can normalize line endings with preg_replace("/\r\n|\n\r|\n|\r/", "\n", $subject);

0

精彩评论

暂无评论...
验证码 换一张
取 消