如何使用gawk解析CSV文件?仅设置FS=","
是不够的,因为包含逗号的引用字段将被视为多个字段。
以下示例使用FS=","
无法正常工作:
文件内容:
one,two,"three, four",five
"six, seven",eight,"nine"
gawk脚本:
BEGIN { FS="," }
{
for (i=1; i<=NF; i++) printf "field #%d: %s\n", i, $(i)
printf "---------------------------\n"
}
错误的输出:
field #1: one
field #2: two
field #3: "three
field #4: four"
field #5: five
---------------------------
field #1: "six
field #2: seven"
field #3: eight
field #4: "nine"
---------------------------
期望的输出结果:
field #1: one
field #2: two
field #3: "three, four"
field #4: five
---------------------------
field #1: "six, seven"
field #2: eight
field #3: "nine"
---------------------------