by shigemk2

当面は技術的なことしか書かない

remove enclose with awk

"5","1211274723","0","D","2"
"1","1211292921","0","A","2"
"5","1211295793","0","A","2"
"5","1211310146","0","A","2"
"5","1211310310","0","A","2"
"4","1211315271","0","A","2"
"5","1211318203","0","D","2"
"2","1211323658","0","A","2"
"5","1211329224","0","A","2"
"5","1211330064","0","A","2"

こういうダブルクオート囲いのCSVから囲いを取り除いて2列目を抽出したい。

1211274723
1211292921
1211295793
1211310146
1211310310
1211315271
1211318203
1211323658
1211329224
1211330064

こう。gsubをつかう。

awk -F',' '{gsub(/"/, "", $2); print $2}' testme.csv

http://www.kt.rim.or.jp/~kbk/gawk-30/gawk_13.html