4 ms·
I always treat CSVs as comma separated values with new line delimiters. If it’s a new line, it’s a new row.
by LPisGood 2y ago
I always treat CSVs as comma separated values with new line delimiters. If it’s a new line, it’s a new row.
- criddell 2y agoDo you ever have CSV data that has newlines within a string?
- thesuitonym 2y agoI don't. If I ever have a dataset that requires newlines in a string, I use another method to store it. I don't know why so many people think every solution needs to to be a perfect fit for every problem in order to be viable. CSV is good at certain things, so use it for those things! And for anything it's not good at, use something else!
- criddell 2y ago> use something else You don't always get to pick the format in which data is provided to you.
- thesuitonym 2y agoTrue, but in that case I'm not the one choosing how to store it, until I ingest the data, and then I will store it in whatever format makes sense to me.
- deleted 2y ago[deleted]
- kittoes 2y agoI don't think we do? It's more that a bunch of companies already have their data in CSV format and aren't willing to invest any effort in moving to a new format. Doesn't matter how much one extolls all the benefits, they know right? They're paying someone else to deal with it.
- LPisGood 2y agoNo - that’s what I’m trying to say. If I have newlines I use something else.