On 6/26/2013 8:48 AM, RSmith wrote:
Expanding on what Jay replied to:
well we could discuss endlessly, what well formed CSV files are.
Not really, the rules are pretty set in stone, it isn't open to
interpretation.
For instance, what is the resulting fields from this CSV: [123, 9" Nail,
", Caliper, "set, up 5"", hold", 8 ]
In REAL CSV terms that would be: 123 | 9 Nail, | Caliper | set, up
5", hold | 8
If by REAL CSV you mean the format specified in RFC 4180, then your
example is not a well-formed CSV input (and the OP's example isn't either):
2.5. If fields are not enclosed with double quotes, then double quotes
may not appear inside the fields.
2.6. Fields containing line breaks (CRLF), double quotes, and commas
should be enclosed in double-quotes.
If, on the other hand, by REAL CSV you mean something other than RFC
4180, then it would appear that the rules are not in fact set in stone,
and are in fact subject to interpretation and disagreement.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
