title: How to trim the new line character of column data in ctl file of SQL Loader
body: <p>My table data has contains new line character it is loading from sql loader ctl file, one column called 'IPADDRESS'is loading with new line character:</p>
  
  <p>My ctl file :</p>
  
  <pre><code> load data
   INFILE 'abc.txt'
   INTO TABLE TABLENAME
   APPEND
   FIELDS TERMINATED BY '\|'
   (MAKE,
   CUST_ID "UPPER(:CUST_ID)",
   IPADDRESS  "REGEXP_REPLACE(:IPADDRESS, '\\.\\D+', '', 1, 0)"
   )
  </code></pre>
  
  <p>Data in table storing is Ex:</p>
  
  <pre><code>Make CUST_ID        IPADDRESS 
  ------------------------------
  C   MPG-VG-ALG01    "9.7.69.37
  "
  C   MPG-VG-ALG03    "9.7.69.39
  "
  </code></pre>
  
  <p>Sample input  file data :</p>
  
  <pre><code>C|mpg-vg-alg01.gdl.mex.ibm.com|9.7.69.37 
  C|mpg-vg-alg03.gdl.mex.ibm.com|9.7.69.39 
  C|mpg-vg-alg04.gdl.mex.ibm.com|9.7.69.23
  </code></pre>