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);

    评论

报告相同问题?

悬赏问题

  • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
  • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
  • ¥15 如何在炒股软件中,爬到我想看的日k线
  • ¥15 seatunnel 怎么配置Elasticsearch
  • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
  • ¥15 (标签-MATLAB|关键词-多址)
  • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
  • ¥500 52810做蓝牙接受端
  • ¥15 基于PLC的三轴机械手程序
  • ¥15 多址通信方式的抗噪声性能和系统容量对比