The horror! CSV is propping up DIVIDER

[Klaus]

Commas? Tabs? Semicolons? Read everything about it here.

https://kb.blackbaud.com/knowledgebase/articles/Article/75155

[George K]

I have no idea what this is all about...but, I'll take your word for it.

[Axtremus]

Comma is the only acceptable answer, it's in the acronym.

[Copper]

I like CSV files

I like Tab separated too

They are very flexible and easy to convert and share

[Klaus]

The CSV import of Excel is a miniature version of everything that is wrong with Microsoft Office.

And I agree with Ax, there's no reason to ever use anything different from comma. There's escape syntax if a comma is necessary elsewhere.

[Mik]

There is EVERY reason to use something other than a comma if your text contains commas. I've written lots of conversions using delimited files and all characters can cause problems if they are in the text. Escape syntax can be extremely cumbersome and requires extra code to get around it.

[Klaus]

@mik said in The horror! CSV is propping up DIVIDER:

There is EVERY reason to use something other than a comma if your text contains commas.

OK. I'm known to be very tolerant regardless of your editorexual orientation, be it Emacs, vi or even nano. But enough is enough. This is a really personal matter to me. You want full-scale war? From now on, I'll take no prisoners anymore. Scorched earth, motherfucker.

[mark]

XML ftw! runs, hides....

[Klaus]

@mark said in The horror! CSV is propping up DIVIDER:

XML ftw! runs, hides....

I've added you to my extermination list.

If you had said JSON we could have still been friends.

Real programmers use s-expressions, of course.

[mark]

@klaus said in The horror! CSV is propping up DIVIDER:

@mark said in The horror! CSV is propping up DIVIDER:

XML ftw! runs, hides....

I've added you to my extermination list.

If you had said JSON we could have still been friends.

Real programmers use s-expressions, of course.

I am an old geek. I just recently started to look at JSON. It does look interesting. Also NoSQL databases look interesting as well. Totally foreign concept to this old DBA, but tech moves forward with or with out me.

[Horace]

I remember 500 page books about how to unlock the power of XML. Nowadays, everybody uses json, which can be described in a paragraph. Simplicity for the win.

[Mik]

@klaus said in The horror! CSV is propping up DIVIDER:

@mik said in The horror! CSV is propping up DIVIDER:

There is EVERY reason to use something other than a comma if your text contains commas.

OK. I'm known to be very tolerant regardless of your editorexual orientation, be it Emacs, vi or even nano. But enough is enough. This is a really personal matter to me. You want full-scale war? From now on, I'll take no prisoners anymore. Scorched earth, motherfucker.

Motherfucker would have been a lot more effective in German. Motherfucker.

[Copper]

I used a bunch of json about 14 or 15 years ago.

It's ok for what it is. I think it is something like wearing a covid mask - you are supposed to like it.

I think json is a little heavy and I prefer tab separated.
But json is ok if there are other people involved.

[Loki]

@copper said in The horror! CSV is propping up DIVIDER:

I used a bunch of json about 14 or 15 years ago.

It's ok for what it is. I think it is something like wearing a covid mask - you are supposed to like it.

I think json is a little heavy and I prefer tab separated.
But json is ok if there are other people involved.

Parsing the json blob, easy for the sender to send the blob but not always a great time for the receiver.

[Klaus]

@copper said in The horror! CSV is propping up DIVIDER:

I used a bunch of json about 14 or 15 years ago.

It's ok for what it is. I think it is something like wearing a covid mask - you are supposed to like it.

I think json is a little heavy and I prefer tab separated.
But json is ok if there are other people involved.

The main point of JSON is the representation of tree-structured data, as opposed to flat tables like CSV.