|
|
|
|
|
by ygra
3206 days ago
|
|
Your CSV would actually look like this instead: full name,address
Homer Simpson,"742 Evergreen Terrace,
Springfield"
"Bart ""El Barto"" Simpson","742 Evergreen Terrace,
Springfield"
(Omitted optional quotes for fields that don't need them). Quotes are escaped with "", and line breaks don't need escaping, they just have to be in a quoted field. And there is no space after a comma, except you want that space to be part of the field's value. |
|
> Omitted optional quotes for fields that don't need them
I think it's good policy to always wrap your contents in quotes regardless of whether you have a delimiter that needs quoting. And in fact many CSV marshallers will do just this.
> And there is no space after a comma
That was added purely for readability on HN. I agree it's not how you'd normally marshal the contents.