Comma Separated Fields (The GNU Awk User’s Guide)
For decades, anyone wishing to work with CSV files and awk had to “roll their own” solution. (For an example, see Defining Fields by Content). In 2023, Brian Kernighan decided to add CSV support to his version of awk. In order to keep up, gawk too provides the same support as his version. To use CSV data, invoke gawk with either of the -k or --csv options.
Fields in CSV files are separated by commas. In order to allow a comma to appear inside a field (i.e., as data), the field may be quoted by beginning and ending it with double quotes. In order to allow a double quote inside a field, the field must be quoted, and two double quotes represent an actual double quote. The double quote that starts a quoted field must be the first character after the comma. Table 4.1 shows some examples.
Persistent-Memory gawk User Manual
Utility-Scale_Industrial_Solar
Utility-Scale_Industrial_Solar_in_the_USA
Potomac River – Fort Ashby, West Virginia
Sunset
Yesterday I visited my old office and happened to catch the sunset.
Taken on Wednesday November 11, 2020 at Alfred E. Smith Building.