News for hackers. Stuff that matters.

A comment on Modernizing AWK, a 45-year old language, by adding CSV support. Parent comment

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by carapace on Thursday May 12, 2022 @11:05AM (#31355262)
I'm just gonna leave this here.

https://git.sr.ht/~sforman/sv/tree/master/item/sv.py

(Python code for ASCII-separated values. TL;DR: it's so stupid simple that I feel any objection to using this format has just got to be wrong. It's like "Hey, we don't have to keep stabbing ourselves in the face." ... "But how will we use our knives?" See? It's like that.)

[ Parent | on HN ]
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by a1369209993 on Friday May 13, 2022 @12:53AM (#31363476)
> any objection to using this format

How do I edit the data file in a text editor?

More generally, how do I edit the entire data file, including field/record/etc seperators, in a editor that can display only characters that are valid content of data fields?

(Not that CSV (barring de-facto-nonstandard extensions like rfc4180's `"b CRLF bb"` and `"b""bb"`) is any good for this either, of course.)

[ Parent | on HN ]
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by CRConrad on Friday May 20, 2022 @04:30AM (#31444771)
> > any objection to using this format

> How do I edit the data file in a text editor?

Use a non-sucky text editor.

For example, AFAICR NotePad++ displays those characters. Windows doesn't have any ultra-easy way to input them, but within NP++ you can copy-paste them.

[ Parent | on HN ]
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by a1369209993 on Saturday May 21, 2022 @05:38PM (#31462127)
> For example, AFAICR NotePad++ displays those characters.

Great! Now go back to the other half of the requirement: how do I store all characters that NotePad++ displays in the content of a data field?

[ Parent | on HN ]
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by CRConrad on Monday May 23, 2022 @02:47AM (#31476012)
These delimiters, you mean? You don't. They're delimiters, they never go in a field. Bam, problem solved. (Or rather, problem didn't exist in the first place.)
[ Parent | on HN ]
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by mro_name on Saturday May 14, 2022 @05:57AM (#31376424)
indeed, if the text editor doesn't care, it's no help. Same for all other characters - be it tab, cr, lf, crlf, รค, and so on.

Choose your tools wisely, I'm not aware the situation.

[ Parent | on HN ]