awk -F'", "'
That's apostrophe, quote, comma, space, end quote, apostrophe.
That's apostrophe, quote, comma, space, end quote, apostrophe.
Name, Age, Address
"James aka ""Jim"", ""licensed"" attorney", 42, "New York"
That's three values: James aka "Jim", "licensed" attorney
42
New York
And there are other possible irregularities: zero or N spaces after the comma separators; unquoted values when they're not needed; backslash-escaped special characters; escaping newlines.Will not work were numeric fields are not quoted.
But nice solution, nevertheless.