The horror! CSV is propping up DIVIDER
-
wrote on 1 Jun 2021, 23:07 last edited by
Commas? Tabs? Semicolons? Read everything about it here.
https://kb.blackbaud.com/knowledgebase/articles/Article/75155
-
wrote on 1 Jun 2021, 23:35 last edited by
I have no idea what this is all about...but, I'll take your word for it.
-
wrote on 1 Jun 2021, 23:54 last edited by
Comma is the only acceptable answer, it's in the acronym.
-
wrote on 2 Jun 2021, 01:23 last edited by
I like CSV files
I like Tab separated too
They are very flexible and easy to convert and share
-
wrote on 2 Jun 2021, 09:40 last edited by
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.
-
wrote on 2 Jun 2021, 12:31 last edited by Mik 6 Feb 2021, 12:32
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.
-
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.
wrote on 2 Jun 2021, 13:30 last edited by Klaus 6 Feb 2021, 13:38@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.
-
wrote on 2 Jun 2021, 14:04 last edited by
XML ftw! runs, hides....
-
wrote on 2 Jun 2021, 14:08 last edited by
@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 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.
wrote on 2 Jun 2021, 15:04 last edited by@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.
-
wrote on 2 Jun 2021, 15:07 last edited by
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 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.
wrote on 2 Jun 2021, 15:39 last edited by@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.
-
wrote on 2 Jun 2021, 15:54 last edited by Copper 6 Feb 2021, 15:55
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. -
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.wrote on 2 Jun 2021, 15:57 last edited by@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.
-
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.wrote on 2 Jun 2021, 19:18 last edited by@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.