title: How to export enumerated list values from DOORS into cells or fields of MATLAB data
body: <p>Here's the situation.  I have an attribute in a DOORS module which allows multiple values of an enumeration list to be selected. If I  export the DOORS module to an Excel workbook and the enumeration values will appear on separate lines in an Excel cell. If I export to a CSV file, each enumeration collection is surrounded with quote-marks; each enum value followed with a CR-LF .  </p>
  
  <p>If I try to import the CSV into MATLAB with <code>readtable</code> , the import fails because some rows in the CSV file are not "full-length" because the corresponding objects in DOORS had empty values for some attributes.  If I import from the Excel worksheet, I can get all the data, but all the enumeration values are "crushed" into a single string. The line-break chars are lost and there's no way to separate the individual enumeration strings. </p>
  
  <p>The reason I'm trying to do all this is that I'd like to have an automated way of dumping all the values in the underlying EnumerationType in DOORS into a cell array in MATLAB for subsequent matching and processing.   I'm trying to avoid having to write (and then distribute to coworkers) a DXL script which collects the individual enumeration values and writes them to an output file -- which among other things separates the enum output from the general export of information from other attributes.  (and probably would make importing to MATLAB painful).   </p>
  
  <p>So: any ideas?  Export/import options I've missed that might help?</p>
  
  <p>Here's an example of the output CSV format.  Everything contained between a pair of '"' comprises one object's enumeration attribute value set. The first row contains the header labels.</p>
  
  <pre><code>ID,Type,ReqStatus,_ApprovalList,_ApprovedBy
  PF_SYS_RC_2436,Functional Requirement,Init,Soe Jivak,
  PF_SYS_RC_2082,Non-Functional Requirement,In Review,"Soe Jivak
  Lord Tyrion
  Jon Snow
  Larry
  Moe
  Curly
  Groucho
  Harpo
  Beppo","Lord Tyrion
  Larry
  Moe"
  PF_SYS_RC_2083,Non-Functional Requirement,In Review,"Jon Snow
  Larry
  Moe",Larry
  PF_SYS_RC_2084,Non-Functional Requirement,In Review,Groucho,
  PF_SYS_RC_2088,Non-Functional Requirement,In Review,"Lord Tyrion
  Moe
  Groucho",Moe
  </code></pre>