一行一行修改一个csv文件 [英] Modify a csv file line by line

查看:176
本文介绍了一行一行修改一个csv文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个大文件,我想修改其中的每一行. 我想使用PHP来快速完成此操作:

I have a big file that I want to modify every line in it. I want to use PHP to do it quickly :

我的文件是CSV文件;

My file is CSV file ;

20010103,02,00,00,0.9496
20010103,03,00,00,0.9504
20010103,04,00,00,0.9499

我想像这样使它能够在Highchart上晚使用:

I want to make it like this to be able to use it late with Highchart:

[Date.UTC(2001,01,03,02,00,00),0.9496],
[Date.UTC(2001,01,03,03,00,00),0.9504],
[Date.UTC(2001,01,03,04,00,00),0.9499],

我如何循环每一行并进行修改?

How canI loop every line and make this modification ?

推荐答案

请参见fgetcsvfputcsv PHP函数.基本上是这样的:

See the fgetcsv and fputcsv PHP functions. It will basically be something like:

if (($handle1 = fopen("input.csv", "r")) !== FALSE) {
    if (($handle2 = fopen("output.csv", "w")) !== FALSE) {
        while (($data = fgetcsv($handle1, 1000, ",")) !== FALSE) {
           // Alter your data
           $data[0] = '...';

           // Write back to CSV format
           fputcsv($handle2, $data);
        }
        fclose($handle2);
    }
    fclose($handle1);
}

这篇关于一行一行修改一个csv文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆