Hello,
In desperate need....
I am needing a macro to save out a BoM on a drawing to .csv file preferably into the same folder the drawing is in so I can import into our business system. I have had a look around but cant find any macros that work.
Thanks,
Yes, SW does not escape commas in text fields, so your CSV is broken if anything in the table contains a comma. I don't know how they missed Rule #1 of CSV exporters, and CSV is quite literally the simplest tabulated format.
This also applies for the new line symbol (i.e. if you have multi-line cell) as it is not properly escaped. I have created a macro which exports CSV table escapting the special symbols and optionally allows to ignore the header from the exporting. Here is the link: Export Table To CSV
How would one go about adding " as a special character to the macro?
Ooh, that's a good one. I will fix and update the macro. Thanks for reporting this.
Issue with " has been fixed. Macro is updated at the same link.
Thank you!
Any particular reason that RMB->Save As doesn't work?