News for hackers. Stuff that matters.
Re:Show HN: Csvbox.io – CSV import button for a web app, Saa... by codeulike on Wednesday May 12, 2021 @11:04AM (#27131186)
Great point, there are so many gotchas with CSV.

Could the app handle this one?

    "First Name","Last Name","Address","Town","Postcode"
    David,O'Leary,"12 Acacia Avenue",London,NW5 3DF
    June,Robinson,"14, Abbey Court","Putney",SW6 4FG
    Greg,Hampton,"",,
    Stephen,James,"""Dunroamin"" 45 Bridge Street",Bristol,BS2 6TG
    Daisy,Smith,"Flat 6,
    Porchester Court,
    24 Dragon Road",Newcastle,NE3 4FG
(i.e. some fields enclosed in speechmarks and some not, commas in text, blank values, escaped speechmarks, carriage returns)

edit: I tried it with the csvbox.io demo - it seemed to deal with it ok!

Re:Show HN: Csvbox.io – CSV import button for a web app, Saa... by spreadr on Wednesday May 12, 2021 @11:15AM (#27131305)
It will work. I have setup a demo for you for this data. Simply create a csv file and upload here - https://app.csvbox.io/upload/HdPOFwRMeU73O3hLMqM98lOB2ABllS?...