Modernizing AWK, a 45-year old language, by adding CSV support

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by gshubert17 on Thursday May 12, 2022 @02:47PM (#31358487)

I think the article already showed that with the example -F,

The problem is commas inside quoted strings, as in the example "Smith, Bob".

I believe the field-separator option on awk will break the quoted string at the interior comma.

[ Parent | on HN ]

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by asdff on Thursday May 12, 2022 @03:06PM (#31358786)

You could just replace those commas within the quote with some other string or remove them if you wanted with some awk or sed. Here is a somewhat relevant example from stackoverflow:

awk -F'"' -v OFS='' '{ for (i=2; i<=NF; i+=2) gsub(",", "", $i) } 1' infile

1. https://unix.stackexchange.com/questions/48672/remove-comma-...

[ Parent | on HN ]

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by WFHRenaissance on Thursday May 12, 2022 @03:42PM (#31359291)

LOL - you guys actually read the articles?

[ Parent | on HN ]