title: Amazon Redshift - COPY from CSV - single Double Quote in row - Invalid quote formatting for CSV Error
body: <p>I'm loading a CSV file from S3 into Redshift.  This CSV file is analytics data which contains the PageUrl (which may contain user search info inside a query string for example).</p>
  
  <p>It chokes on rows where there is a single, double-quote character, for example if there is a page for a 14" toy then the PageUrl would contain:</p>
  
  <p><a href="http://www.mywebsite.com/a-14" rel="noreferrer">http://www.mywebsite.com/a-14</a>"-toy/1234.html</p>
  
  <p>Redshift understandably can't handle this as it is expecting a closing double quote character.</p>
  
  <p>The way I see it my options are:</p>
  
  <ol>
  <li>Pre-process the input and remove these characters</li>
  <li>Configure the COPY command in Redshift to ignore these characters but still load the row</li>
  <li>Set MAXERRORS to a high value and sweep up the errors using a separate process</li>
  </ol>
  
  <p>Option 2 would be ideal, but I can't find it!  </p>
  
  <p>Any other suggestions if I'm just not looking hard enough?</p>
  
  <p>Thanks</p>
  
  <p>Duncan</p>