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.