title: Redshift - Delimited value missing end quote
body: <p>Im trying to load a CSV file to redshift.</p>
  
  <p>Delimiter '|'  </p>
  
  <p><strong>1'st column of CSV:</strong></p>
  
  <pre><code>1 |Bhuvi|"This is ok"|xyz@domain.com
  </code></pre>
  
  <p>I used this command to load.</p>
  
  <pre><code>copy tbl from 's3://datawarehouse/source.csv'   
  iam_role  'arn:aws:iam:::role/xxx'cas-pulse-redshift' 
  delimiter '|' 
  removequotes 
  ACCEPTINVCHARS ; 
  </code></pre>
  
  <p><strong>ERROR:</strong></p>
  
  <pre><code>raw_field_value | This is ok" |xyz@domain.com
  err_code        | 1214
  err_reason      | Delimited value missing end quote
  </code></pre>
  
  <p>then I tried this too.</p>
  
  <pre><code>copy tbl from 's3://datawarehouse/source.csv'   
  iam_role  'arn:aws:iam:::role/xxx' 
  CSV QUOTE '\"' 
  DELIMITER '|'   
  ACCEPTINVCHARS ; 
  </code></pre>