3 ms·
> 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 woul
by u801e 6y ago
> 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.
- ganstyles 6y agoI 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.
- u801e 6y agoI 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.
- yiyus 6y ago> 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.
- BiteCode_dev 6y agoCompose, rarely. Read and edit with plain text editor, it's common.
- mywittyname 6y agoI did it like three times already today.
- u801e 6y agoWhat editor did you use?
- mywittyname 6y agovim / sublime text, depending on context. I do a lot of troubleshooting using CLI tools like grep and wc.
- Kluny 6y agoIn 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.