用php编辑csv

Question

我有大约700行的csv。它包括如下行：92265R-1,192526R-3,0...现在，我的目标是将每一行复制到新的csv，其中每行以_x结尾复制5次。因此最终的csv将如下所示：92265R-1_1,192265R-1_2,192265R-1_3,192265R-1_4,192265R-1_5,192526R-3_1,092526R-3_2,092526R-3_3,092526R-3_4,092526R-3_5,0... 我被困在这里

Answer 1

只需尝试一下

$newArray = [];

if (($handle = fopen("test.csv", "r")) !== FALSE) {

while (($row = fgetcsv($handle, 1000, ",")) !== FALSE) {

  for($i=1 ; $i <=5 ; $i++){

    $newArray[] = [

            $row[0].'_'.$i,

            $row[1]

        ];

   }

  }

  fclose($handle);

}

$fp = fopen('new.csv', 'w');

foreach ($newArray as $fields) {

    fputcsv($fp, $fields);

}

fclose($fp);