title: cfspreadsheet escape comma in comma separated row insert
body: <p>The function for adding a row to a coldfusion spreadsheet is <code>SpreadsheetAddrow</code> which accepts data as "A comma delimited list of cell entries, one per column."</p>
  
  <p>Some of my data has commas within it. How do I escape the commas within my data without escaping the commas in the list?</p>
  
  <p>I am currently creating an array with the contents of the row, then converting it to a list to add to the spreadsheet:</p>
  
  <pre><code>    &lt;cfset row = ArrayNew(1)&gt;
      &lt;cfloop list="#structKeyList(setRecord.columns)#" index="key"&gt;
          &lt;cfset ArrayAppend(row, "#Evaluate(key)#")&gt;
      &lt;/cfloop&gt;
      &lt;cfset spreadsheetAddRow(xlsObj, "#ArrayToList(row)#")&gt;
  </code></pre>