title: COPY ignore blank columns
body: <p>Unfortunately I've got some huge number of csv files with missing separator as following. Notice the second data got only 1 separator with 2 values. Currently I'm getting "delimiter not found error".</p>
  
  <p>Only if I could insert NULL to 3rd column in case there is only two values.</p>
  
  <pre><code>1,avc,99
  2,xyz
  3,timmy,6
  </code></pre>
  
  <p>Is there anyway I can COPY this files into Redshift without modifying CSV files?</p>