[ferrari8608]

awk -F'", "'

That's apostrophe, quote, comma, space, end quote, apostrophe.

[Rangi42]

Which still fails if the values contain escaped quotes:

    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.

[Rotten194]

What if not all columns are quoted? A lot of the time only the columns that need quoting are quoted and the others are bare.

[z92]

Nice solution.

Will not work were numeric fields are not quoted.

But nice solution, nevertheless.