###前提・実現したいこと
今現在PHPを使いCSVデータの整形を行なっているのですが、上手にいきません。
PHPにCSVのデータを読み込むことはできたのですが、指定した箇所の削除ができません。
指定したデータを削除し出力したいです。
###発生している問題・エラーメッセージ
こちらが使用しているCSVデータです。
12345,,,,xx市,,,,2011/1/1,男,"222,412","1,956","1,905","2,053","1,938","2,032","2,028","2,037","2,100","2,115","2,189","2,110","2,072","2,128","2,185","2,187","2,336","2,254","2,362","3,047","3,213","2,963","2,759","2,882","3,048","3,172","3,253","3,353","3,165","3,192","3,072","3,040","3,089","3,183","3,306","3,199","3,151","3,143","3,291","3,261","3,181","3,160","3,338","3,561","3,743","3,837","3,666","3,520","3,227","3,360","3,290","2,905","2,622","2,810","2,726","2,696","2,468","2,283","2,391","2,552","2,197","2,254","2,339","2,326","2,348","2,337","2,464","2,849","3,031","3,448","3,199","2,854","1,853","2,145","2,355","2,142","2,249","1,995","1,700","1,375","1,432","1,312","1,106",963,802,728,657,610,490,393,335,275,242,145,98,68,70,40,28,19,13,10,4,3,3,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"43,506"
11111,,,,xx市,,,,2011/6/1,女,"202,921","1,843","1,894","1,879","1,828","1,905","1,931","2,012","2,031","1,980","2,038","2,014","1,975","2,037","2,078","2,092","1,975","2,099","2,075","2,274","2,176","2,250","2,094","2,268","2,121","2,150","2,206","2,143","2,280","2,340","2,263","2,450","2,482","2,471","2,619","2,517","2,562","2,690","2,686","2,670","2,812","2,871","2,926","3,199","3,336","3,310","3,280","3,064","2,903","2,930","2,862","2,603","2,308","2,413","2,256","2,372","2,239","2,241","2,297","2,304","2,159","2,214","2,263","2,341","2,372","2,637","2,724","2,836","3,074","3,365","3,470","2,758","1,772","2,239","2,420","2,175","2,210","1,979","1,726","1,421","1,489","1,388","1,386","1,210","1,190","1,064",962,907,824,753,701,619,525,422,322,276,225,176,135,92,71,32,29,17,11,4,5,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"49,011"
このデータの指定した部分だけ(数値など)の削除を行いたいです。
<?php setlocale(LC_ALL, 'ja_JP.UTF-8'); $file = 'data.csv'; $data = file_get_contents($file); $temp = tmpfile(); $csv = array(); $key = 0; fwrite($temp, $data); rewind($temp); while (($data = fgetcsv($temp, 0, ",")) !== FALSE) { $csv[$key] = $data; $key = $key + 1; } //削除実行 unset($csv[0]); print_r($csv); fclose($temp); var_dump($csv);
よければ回答よろしくお願いします。
回答1件
あなたの回答
tips
プレビュー