使用 gawk 解析 CSV 文件

如何使用 gawk 解析 CSV 文件？简单设定FS=","还不够，因为内部带有逗号的引用字段将被视为多个字段。

使用示例FS=","这不起作用：

文件内容：

one,two,"three, four",five
"six, seven",eight,"nine"

呆呆的脚本：

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"
---------------------------

gawk 第 4 版手册 http://www.gnu.org/software/gawk/manual/html_node/Splitting-By-Content.html说要使用FPAT = "([^,]*)|(\"[^\"]+\")"

When FPAT被定义，它禁用FS并按内容而不是按分隔符指定字段。