I'm testing out the script example Robin posted under 'Documents' called Read BOM information in Enterprise PDM. I kept running into a problem where it would throw a Null exception on ln 113
Now the data is coming into the CSV but I have a problem becuase some cell values actually contain a ','. So what I am looking for is a way to keep the cell values intact when they are passed into the CSV; example, 'SHEET, 14 GAUGE 310SS (CUT TO 2 3/8" DIA. WITH 3/8" DIA. HOLE IN CENTER)', this value should come in as one line but it separates becuase of the ',' after SHEET.
Is there a way to either wrap each value in a ' or " before it is written so that I can add one of those as a delimiter as well?
I've attached the CSV output for persual as well.
disclosure: I'm a VB/API newb so speak slowly
SolidworksApi macros