evilGmonkey / opendatakit

Automatically exported from code.google.com/p/opendatakit
0 stars 0 forks source link

Suggestions for Briefcase CSV #217

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
From Manna Energy

null fields show in the briefcase csv as nothing so you end up with a bunch of 
commas in a row when there is a null value from an optional field that was 
skipped. This, combined with the fact all the other fields with values have 
quotation marks, makes it difficuilt to parse the csv via delimiters. Cant use 
commas because those can be in the strings as well, but you cant use "," either 
because the null fields are lacking quotes. We had to resort to some craftyness 
to properly delimit the csv. 

Original issue reported on code.google.com by wbrune...@gmail.com on 20 May 2011 at 10:13

GoogleCodeExporter commented 9 years ago
There's actually an RFC describing CSV file formats.  
The complaints are a critique of the CSV file format, which Briefcase adheres 
to:

http://tools.ietf.org/html/rfc4180

Changing to documentation.

Original comment by mitchellsundt@gmail.com on 30 Jan 2012 at 10:04