Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user2688276May 19 2016 — edited May 20 2016

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 17 2016
Added on May 19 2016
12 comments
2,996 views