dongxie3963 2014-05-21 18:24
浏览 82

从PHP中的CSV文件中删除回车

I'm trying to write a php file to eliminate carriage returns in a CSV file. I am trying to first read from the original CSV file containing the carriage returns in column 1. Next, trim or eliminate the carriage returns and then write the corrected string into a new CSV file. But I'm having some trouble on how to specifically do that. I received an error on this program and I'm not sure what's the problem with this code. What am I missing here? Any suggestions?

Here is my original code:

<?php
$file_read = fopen('testCarriageFile.csv', "r");
$file_write = fopen('testCarriageFile2.csv', "w+");
while(!feof($file_read)) {
    $file_trim = trim($file_read, "");
    fwrite($file_write, $file_trim);
}
fclose($file_read);
fclose($file_write);
?>
  • 写回答

1条回答 默认 最新

  • douji1999 2014-05-21 18:32
    关注

    You are not reading anything from the file. You need to use fgets or fgetcsv for CSV files. Try this:

    while(!feof($file_read)) {
        $file_line = fgets($file_read);
        $file_trim = trim($file_line, "");
        fwrite($file_write, $file_trim);
    }
    

    Not sure why you are removing carriage returns when you could just use fgetcsv to read CSV file and if you are not sure about line endings use ini_set("auto_detect_line_endings", true);

    评论

报告相同问题?

悬赏问题

  • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号
  • ¥50 安装pyaudiokits失败
  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
  • ¥15 让node服务器有自动加载文件的功能
  • ¥15 jmeter脚本回放有的是对的有的是错的
  • ¥15 r语言蛋白组学相关问题