3 ms·
Not when the data is like this. "Richard, Martin", "23 NS, North Coast, NY" Comma frequently occurs inside texts, and then awk fails.
by z92 11y ago
Not when the data is like this.
"Richard, Martin", "23 NS, North Coast, NY"
Comma frequently occurs inside texts, and then awk fails.
- ferrari8608 11y agoawk -F'", "' That's apostrophe, quote, comma, space, end quote, apostrophe.
- Rotten194 11y agoWhat 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 11y agoNice solution. Will not work were numeric fields are not quoted. But nice solution, nevertheless.
- Rangi42 11y agoWhich 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.