title: Azure Data Factory CSV with double quotes
body: <p>I have a pipeline that retrieves an FTP hosted CSV file. It is comma delimited with double quote identifiers. The issue exists where a string is encapsulated in double quotes, but the string itself contains double quotes.</p>
  
  <p>string example: <code>"Spring Sale" this year.</code></p>
  
  <p>How it looks in the csv (followed and lead by two null columns): </p>
  
  <pre class="lang-none prettyprint-override"><code>"","""Spring Sale"" this year",""
  </code></pre>
  
  <p>SSIS handles this fine, but Data Factory wants to transform it into an extra column that isn't separated by a comma. I have removed the extra quotes on this line and it works fine.</p>
  
  <p>Is there a way around this besides altering the source?</p>