Message 1 of 3
Improper CSV formatting in BOM export
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
When I export the BOM from the schematic view in CSV format, strings (such as part description) which happen to contain a double quote are represented verbatim in the CSV output file, as seen here:
Per RFC-4180 page 2:
7. 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. For example: "aaa","b""bb","ccc"
I acknowledge that RFC-4180 isn't a formal standard, though it seems like the closest thing that exists for CSV. Some of the downstream tools I tried are able to gracefully handle the lack of escaping, while others do not; unfortunately this breaks my workflow, requiring me to fix the exported CSV every time.