我有一个文本文件text.csv
,日期是这样安排的。
name1
2010-01-02 (i)
2010-05-07 (i)
2010-06-12 (i)
name2
2010-01-02 (i)
2010-05-07 (i)
2010-06-12 (i)
name3
2011-01-05 (i)
2011-05-05 (i)
2011-06-14 (i)
我想将文件重新格式化或写入2列,如下所示:
+---------------+-----+
| 2010-01-02 (i)|name1|
| 2010-05-07 (i)|name1|
| 2010-06-12 (i)|name1|
| 2010-01-02 (i)|name2|
| 2010-05-07 (i)|name2|
| 2010-06-12 (i)|name2|
| 2011-01-05 (i)|name3|
| 2011-05-05 (i)|name3|
| 2011-06-14 (i)|name3|
+---------------+-----+
逻辑应该是这样的:
if line doesn't contain "(i)", name=value
else
write date=value, name to file
我不想使用PHP,但我可以遍历数据:
<?php
$file = file($path);
foreach($file as $value)
{
if ( strpos($value, "(i)" ) !== false)
$name = $value;
$fp = fopen('data.csv', 'w');
fputcsv($fp, $line);
fclose($fp);
}
你能提供一个可以让我开始的python例子吗?它需要在Libre office calc中作为宏运行。
https://stackoverflow.com/questions/24587997
复制相似问题