Improper CSV formatting in BOM export

Improper CSV formatting in BOM export

evan.dudzik
Participant Participant
239 Views
2 Replies
Message 1 of 3

Improper CSV formatting in BOM export

evan.dudzik
Participant
Participant

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:

Screenshot 2023-03-22 203455.png

 

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.

0 Likes
240 Views
2 Replies
Replies (2)
Message 2 of 3

jorge_garcia
Autodesk
Autodesk

Hi @evan.dudzik,

 

I hope you're doing well. I'll put this in as a feature request, in the meantime it may be easier to go into the library connector description and swap the " for the word inch and then from then on you won't have to fix the BOM.

 

Let me know if there's anything else I can do for you.

 

Best Regards,



Jorge Garcia
​Product Support Specialist for Fusion 360 and EAGLE

Kudos are much appreciated if the information I have shared is helpful to you and/or others.

Did this resolve your issue? Please accept it "As a Solution" so others may benefit from it.
0 Likes
Message 3 of 3

evan.dudzik
Participant
Participant
Thanks. I prefer not to clone and modify built-in libraries (in this case, 'con-molex') if I can avoid it, for obvious reasons. I look forward to a fix in a future update.
0 Likes