一行一行修改一个csv文件 [英] Modify a csv file line by line
本文介绍了一行一行修改一个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 ?
推荐答案
请参见fgetcsv
和fputcsv
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屋!
查看全文