Hacker News new | past | comments | ask | show | jobs | submit login

awk -F'", "'

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




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.


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.


Nice solution.

Will not work were numeric fields are not quoted.

But nice solution, nevertheless.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: