News for hackers. Stuff that matters.
Re:So you want to write your own CSV code (2014) by u801e on Friday May 15, 2020 @09:38AM (#23191993)
> CSVs are human readable and writeable and humans tend to have a comma sign on their keyboard

Do people usually compose CSV data by hand? I thought they would use a program like Excel, enter or generate their data in separate cells and then save the file as a CSV. There's no reason why a program like Excel (or any other program for that matter) couldn't use the record separator instead of a comma as a delimiter when generating or consuming such files.

Re:So you want to write your own CSV code (2014) by BiteCode_dev on Friday May 15, 2020 @10:22AM (#23192510)
Compose, rarely. Read and edit with plain text editor, it's common.
Re:So you want to write your own CSV code (2014) by mywittyname on Friday May 15, 2020 @11:50AM (#23193591)
I did it like three times already today.
Re:So you want to write your own CSV code (2014) by u801e on Friday May 15, 2020 @12:04PM (#23193750)
What editor did you use?
Re:So you want to write your own CSV code (2014) by mywittyname on Friday May 15, 2020 @03:52PM (#23196642)
vim / sublime text, depending on context.

I do a lot of troubleshooting using CLI tools like grep and wc.

Re:So you want to write your own CSV code (2014) by ganstyles on Friday May 15, 2020 @09:58AM (#23192233)
I do quite a bit for GitHub markdown tables, for making small annotations for ML, for python parsing, etc. Very common and would be annoying too open up excel every time I needed some csv.
Re:So you want to write your own CSV code (2014) by u801e on Friday May 15, 2020 @12:13PM (#23193845)
I thought markdown tables used the pipe character as the delimiter between table columns.

Also, is not necessary to use excel, and a lot of the issues brought up in the article wouldn't be the case with a different delimiter character. Editors could easily be updated to make entering that delimiter character easier to enter by mapping it to a key like tab whenever a file like that is opened.

It just seems like a problem that could be solved, but can't be due to inertia.

Re:So you want to write your own CSV code (2014) by yiyus on Friday May 15, 2020 @12:37PM (#23194140)
> I thought markdown tables used the pipe character as the delimiter between table columns.

Markdown (the original one by John Gruber) does not include any syntax for tables. Other implementations have included it, but there is no standard. As far as I know, using the pipe character to separate columns is indeed quite common, but it is not the only way.

Re:So you want to write your own CSV code (2014) by Kluny on Friday May 15, 2020 @11:41AM (#23193466)
In my experience, they'll have a database that they administrate through excel, then output it as CSV for whatever tool that needs to process it.