title: How to deal with commas and Quotations in data when exporting to a CSV file
body: <p>I have a table that I am exporting via an SQL server table into a CSV file, via the flat file connection manager.</p>
  
  <p>What I have done is in the Flat File Connection Manager I have used " (double-quote) as the Text Qualifier, which keeps the original data in the same column. </p>
  
  <p>However for a couple of cells I run into the problem where the data originally had double-quotation marks and commas within them. </p>
  
  <p>For instance, </p>
  
  <blockquote>
    <p>Shaquille "Shaq" O'Neal, LLC </p>
  </blockquote>
  
  <p>I don't want to change the data within the database. I also don't want to do it the quick and dirty way, ie. "save as xlsx through a query and then save as CSV".</p>
  
  <p>Thanks</p>