Timeline for Reading in a CSV file using while IFS= but not treating the comma as the separator if the field is in quotations
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 22, 2021 at 14:31 | comment | added | Ed Morton | @Prospero I'm just describing a regexp that matches the contents of a field in a CSV - either a series of non-,s or a string within "s which can include ,s. See gnu.org/software/gawk/manual/gawk.html#Splitting-By-Content for more on FPAT and see whats-the-most-robust-way-to-efficiently-parse-csv-using-awk for more on parsing CSVs with awk in general. | |
| Jun 22, 2021 at 14:13 | comment | added | Prospero | Thanks. Could you explain the logic for this? I don't understand the line BEGIN { FPAT="[^,]*|\"[^\"]*\"" } | |
| Jun 22, 2021 at 2:27 | history | answered | Ed Morton | CC BY-SA 4.0 |