On Sat, 20 May 2023, American Citizen wrote:
1. using awk -F, fails when a cell contains a quoted cell with an embedded comma
I download .csv files from agency databases where strings are double quoted
and contain commas within them, as well as using commas to separated fields.
I start my gawk script with
BEGIN { FS="," }
and it separates (or counts, or selects) fields ignoring commas within
quoted strings.
Rich
