title: Sql loader - second enclosure string not present
body: <p>I am loading a .csv file data into oracle table through sql loader. One of the fields has a new line character (CRLF) in its data and so, am getting the below error:</p>
  
  <p>second enclosure string not present</p>
  
  <p>This is my control file</p>
  
  <pre><code>load data
  characterset UTF8
  infile 'C:\Users\lab.csv'
  truncate 
  into table test_labinal
  fields terminated by ";" optionally enclosed by '"' 
  TRAILING NULLCOLS
        ( 
  
      STATEMENT_STATUS ,
      MANDATORY_TASK ,
      COMMENTS CHAR(9999)  "SubStr(:Comments, 0, 1000)"
  )
  </code></pre>
  
  <p>The field COMMENTS has a new line character in one of its records. Can any one suggest a solution for this.</p>
  
  <p>Thanks</p>