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


      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.


      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.