Python Read csv - Don't consider comma when its within the quotes, even if the quotes are not immediate to the separator
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2022 02:39 PM
I have data like, below and when reading as CSV, I don't want to consider comma when its within the quotes even if the quotes are not immediate to the separator (like record #2). 1 and 3 records are good if we use separator, but failing on 2nd record
Input:
col1, col2, col3
a, b, c
a, b1 "b2, b3" b4, c
"a1, a2", b, c
Output: