[OSGeo-Standards] CSV spatial data on the web

Oliver Tonnhofer olt at bogosoft.com
Wed Feb 17 05:02:42 PST 2016


Hi Stefan,


> On 17.02.2016, at 13:53, Stefan Keller <sfkeller at gmail.com> wrote:
> 
> 2016-02-17 11:48 GMT+01:00 Jeremy Palmer <JPalmer at linz.govt.nz>:
>>> Allowing non-printable control-characters in strings makes it very
>>> complicated and disables mainly all existing CSV software.
>> 
>> Yes but Excel handles it. So does OGR and QGIS Delimited Text Provider.
>> From memory the Microsoft ODBC CSV driver doesn’t - but that’s got lots of issues.
> 
> No, it does'nt handle linebreaks as one record - nor is this allowed
> in any of the CSV standardization approaches I know.

RFC4180 allows newlines as long as they are inside of double quotes. This is at least supported by the Python and Go standard libraries, not sure how other software handles this.



Regards,
Oliver


More information about the Standards mailing list