3 ms·
There is no normal csv! I always used Excel as the “standard” when writing a CSV parser. If every field is quoted you can indeed remove the first and last “, t
by datascienced 3y ago
There is no normal csv! I always used Excel as the “standard” when writing a CSV parser.
If every field is quoted you can indeed remove the first and last “, then split on “,“ and then replace “” with “
in the fields. Excuse my phone converting the quotes!
- int_19h 3y agoThat is precisely why I put "normal" in quotes. Nevertheless, if there is a way to escape anything at all, usually it is the quotation mark, and usually it is escaped by doubling. Pretty much any other scheme is very unlikely to be properly interpreted in this context.
- datascienced 3y agoYes indeed. To make it easy to parse everything has to be quoted. If some things are quoted then you can’t just split on comma because for example:m “, is a cat”,”, is my boyfriend”,123 etc.