undefined | Better HN

0 pointsLPisGood1y ago0 comments

I always treat CSVs as comma separated values with new line delimiters. If it’s a new line, it’s a new row.

0 comments

Do you ever have CSV data that has newlines within a string?

I 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!

criddell1y ago

> use something else

You don't always get to pick the format in which data is provided to you.

1 more reply

kittoes1y ago

I 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.

LPisGoodOP1y ago

No - that’s what I’m trying to say. If I have newlines I use something else.

0x0731y ago

Wouldn't work if csv is used as a exchange format with external companies.

1 more reply

j / k navigate · click thread line to collapse