{"id":6395,"date":"2011-04-03T21:00:50","date_gmt":"2011-04-03T12:00:50","guid":{"rendered":"http:\/\/www.sssg.org\/blogs\/hiro345\/?p=6395"},"modified":"2011-04-16T11:19:25","modified_gmt":"2011-04-16T02:19:25","slug":"%e3%82%b9%e3%82%af%e3%83%aa%e3%83%97%e3%83%88-2","status":"publish","type":"post","link":"https:\/\/www.hiro345.net\/blogs\/hiro345\/archives\/6395.html","title":{"rendered":"CSV\u30d5\u30a1\u30a4\u30eb\u3092\u52a0\u5de5\u3057\u3066\u3001\u3044\u308d\u3044\u308d\u3084\u308a\u305f\u3044\u3068\u304d\u306b\u53c2\u8003\u306b\u306a\u308b\u30b9\u30af\u30ea\u30d7\u30c8"},"content":{"rendered":"

\u3061\u3087\u3063\u3068\u3057\u305f\u30b7\u30a7\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u66f8\u3044\u3066\u307f\u305f\u306e\u3067\u8a18\u9332
\n<\/p>\n

CSV\u30d5\u30a1\u30a4\u30eb\u3092\u52a0\u5de5\u3057\u3066\u3001\u3044\u308d\u3044\u308d\u3068\u3084\u308a\u305f\u3044\u3068\u304d\u306b\u3001\u53c2\u8003<\/p>\n

wget http://localhost/sample.csv
\nhead -1 sample.csv | sed 's/ UPDATE//g' > a.txt
\nhead -3 sample.csv | tail -1 | awk 'BEGIN { FS=","} {print $1}' > b.txt
\ntail -24 sample.csv | grep -v ",0," |sed 's/,\([0-9]\):/,0\1:/' - | \
\n awk 'BEGIN { FS=","} {printf("%s %s,%s,%s,%s,%s\n",$1, $2, $1, $2, $3, $4);}' > c.txt
\ncat s.txt c.txt | sort | uniq | tail -48 > d48.txt
\ncat d48.txt | tail -12 > d.txt
\nmv d.txt s.txt\n<\/div>\n

\u300c\u8a73\u89e3 \u30b7\u30a7\u30eb\u30b9\u30af\u30ea\u30d7\u30c8<\/a>\u300d\u3084\u300cUNIX\u30b7\u30a7\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u30cf\u30f3\u30c9\u30d6\u30c3\u30af<\/a>\u300d\u306a\u3069\u3067\u52c9\u5f37\u3057\u3066\u307f\u308b\u3068\u826f\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n

\u95a2\u9023\u66f8\u7c4d\uff1a
\n