0 Replies Latest reply on Aug 30, 2019 7:47 PM by user11999819

    sql loader skipping rows with carriage returns values.

    user11999819

      Hi,

       

      I am trying to load csv file with sql loader but failing for the rows tha contains carriage returns. I can I process the rows with carriage returns. Tried multiple solutions found online but none of them working.

       

      Here is my control file:

       

      OPTIONS (SKIP=1)

      LOAD DATA

      INFILE 'TestData.csv'

      INTO TABLE TEMP_TEST

      TRUNCATE

      FIELDS CSV WITH EMBEDDED TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS

         (

           CUST_ID,

           C000,

           C001,

           C0002,

           TEXT_NOTES);

       

      the csv file have field called TEXT_NOTES with text spanning across multiple lines.

       

      Please let me know.

       

      Thanks,