Always have a comma in your password, if part of a leak it will break the CSV

Re:Always have a comma in your password, if part of a leak i... by gruez on Thursday October 03, 2024 @07:52PM (#41736325)

AFAIK it's only "ambiguous" in the sense that if you get a csv file you can't determine the exact parsing behavior to use, but if you know what program created the csv (or what encoder options were used), it's not ambiguous to parse.

>but things get really hairy really fast when you start adding types or BLOBs in the CSV.

AFAIK BLOBs are hex encoded, which make them a non issue.

[ Parent | on HN ]

Re:Always have a comma in your password, if part of a leak i... by lazide on Friday October 04, 2024 @01:04AM (#41737985)

Hah! Half the time people will even do silly things like cat together multiple CSVs from different sources.

If blobs got consistently hex encoded, that would also be nice. Base64 is common, and there are multiple types of base64 encoding people use too.

Personally, I tend to think of CSV imports as something you can expect to have a ‘yield’ - and it’s never 100%.

[ Parent | on HN ]

Re:Always have a comma in your password, if part of a leak i... by amy-petrik-214 on Friday October 04, 2024 @06:33PM (#41746131)

yea so just do BSV or bell separated file. We already have "\n" newline separated files. We just need a cel seperator, '\b'. Problem solved.

[ Parent | on HN ]

Re:Always have a comma in your password, if part of a leak i... by lazide on Saturday October 05, 2024 @12:12AM (#41747670)

On the plus side, accidentally cat’ng it to your terminal will be pleasantly musical.

[ Parent | on HN ]