12 Replies Latest reply on May 20, 2016 6:31 AM by BluShadow

    Importing CSV to Table with new line in a field using sql developer

    user2688276

      Hi ,

       

      I have a CSV with ~200-500K records. Few of the Records  have newline inside a field which is enclosed in Double Quotes.

      For Example

      One record looks like this.

      name,id,lname,"Comments

      Comments cont",puid,date

       

      Am trying to load it into a table in Oracle. when i load as CSV, am getting error and if i ignore and continue, the second part of the record is getting inserted as a new record.

       

      If load from xls it works ok, but as i have 200K records xls breaks it to 65K. Is there a way to handle it? I am sure many might have seen this and addressed the same. Would appreciate any help.

       

      I did some search and did not find anything as a solution though found few discussions on the thread.