awk CSV parsing using FPAT result in wrong output [duplicate]

Question

I need to parse some CSV and there is a limitation that it has to be awk/bash. The below is the best I got, but it returns

Ecology",Biology

but I would need "PhD, Ecology". Any help would be very much appreciated!

echo '6,John Smith,"PhD, Ecology",Biology Department' |
    awk 'BEGIN{FPAT = "\"[^\"]*\"|[^,]*"} {print $3}'

awk version 20200816

MacOS.

Hm.. I'm on Mac, awk version 20200816. Will check if I can get a different version. — M3RS
– M3RS, Commented Mar 6, 2024 at 12:36
same command with gawk instead works fine, thanks a lot for the comment!!! — M3RS
– M3RS, Commented Mar 6, 2024 at 12:37
Looks you don't have GNU awk, that's the reason. Try to install GNU version with homebrew: brew install gawk — Gilles Quénot
– Gilles Quénot, Commented Mar 6, 2024 at 12:37

Gilles Quénot · Accepted Answer · 2024-03-06 12:39:24Z

0

It looks like you don't use GNU awk.

You need to install GNU version with homebrew:

brew install gawk

answered Mar 6, 2024 at 12:39

Gilles Quénot

188k43 gold badges232 silver badges229 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1