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)