← All bug reports

FS#2419dwg2csv quote handling

Type
Bug
Status
Closed
Resolution
Fixed
Category
dwg2csv
Severity
Low
Priority
Low
Reported version
3.27.8
Operating system
All
Reported
2022-11-03 by jon_s
Closed
2022-11-03 by andrew
Votes
1

When a text string contains a double quote(") character, the value is not quoted.
If the text string contains a comma, the value is quoted (using double quotes).

When a text string starts with a double quote, it is unclear which of the above two states is correct, making for difficult parsing. (Excel seems to assume the second state when possible)

It would make parsing much easier if the output csv followed the format provided in rfc4180, namely that

If fields are not enclosed with double quotes, then double quotes may not appear inside the fields

(2.5)

If double-quotes are used to enclose fields, then a double-quote appearing inside a field must be escaped by preceding it with another double quote

(2.7)