doupu0619 2015-11-02 16:04
浏览 450
已采纳

Sed - 从csv文件中删除空行

I am trying to extract some .csv files from gz (compressed) files. I want to delete the rows in the excel file that are blank. I am using the code below but it does not work :

$entoli = 'zcat ' . str_replace(' ', '\ ', $filePath) . ' | sed \'/^\s*$/d\'  > ' . str_replace(' ', '\ ', $savePath);
exec($entoli);

where $filePath is the directory of the original compressed and $savePath is the directory where the extracted file will be saved. Also, I am using str_replace(' ', '\ ', ....) just in case there are spaces in the path.

I used this code before in order to delete the rows that do not start with the date format and it works :

$entoli = 'zcat ' . str_replace(' ', '\ ', $filePath) . ' | sed \'/^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]/!d\'  > ' . str_replace(' ', '\ ', $savePath);
exec($entoli);

so, I presume that only this line has to be changed :

sed \'/^\s*$/d\'
  • 写回答

1条回答 默认 最新

  • douchen1988 2015-11-02 16:34
    关注

    After trying to use different syntax, I managed to make it work :

    $entoli = 'zcat ' . str_replace(' ', '\ ', $filePath) . ' | sed \'/^,,,,/d\'  > ' . str_replace(' ', '\ ', $temp);
    exec($entoli);
    

    It works with awk too:

    $entoli = 'zcat ' . str_replace(' ', '\ ', $filePath) . ' | awk \'!/^,,,,/\'  > ' . str_replace(' ', '\ ', $temp);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 C++对比不同编码下相同字符串
  • ¥15 pyqt5设计界面控件之间的空白想消除
  • ¥15 想请教大家关于机器学习的问题
  • ¥15 虚幻UE保存Actor位置失败
  • ¥15 多个.nii合并为.nii.gz格式
  • ¥50 现在需要统计2023年全年 “签收时间(qssj)” 到 “提交时间(tjsj)” 小于半小时的业务量,但是要排除掉周末的时间,同时还要排除中午休息的时间。
  • ¥50 opencv模板匹配为何图像差别大仍然匹配数值高?
  • ¥15 如何成功完成主菜单和分菜单的代码编程C++
  • ¥15 怎样采集或者其它途径拿到全国最新个体工商户数据
  • ¥20 我是一名大学生,想学习java是自学还是报培训班呢