Podcastindex-org/database

CSV: handling of line breaks

saerdnaer opened this issue 4 years ago · 1 comments

saerdnaer commented 4 years ago

According to RFC4180 CSV should always use CRLF (aka \r\n) as line breaks:

 aaa,bbb,ccc CRLF
 zzz,yyy,xxx CRLF

Even for line breaks inside of fields (example 6, page 2):

"aaa","b CRLF
bb","ccc" CRLF
zzz,yyy,xxx

Right now https://archive.org/details/podcastindex_dump contains CRLF for line breaks at the end of a record, but only CR for line breaks inside of fields.

datamythology commented 4 years ago

I don't think the current csv output is suppose to be "used"
Just a quick & dirty output for us to look at some of the fields.