Issue in import the file to sql developer giving error:Line contains invalid enclosed character data or delimiter at position.
I have the following data in csv file while importing it is giving error. I have lot of data.
column has double quotes around it and also line break. I need a line break not double quotes.
Test row
"ab 1
a/b
abc"
c/d 2
--------all my files i load in excel. so i converted to excel.
When i save it as excel it is not letting me to go next at all because of double quotes.
i did clean(test column). then i am able to load the data but it is removing line breaks. i need line breaks.
Please help resolve this issue.
expected ..
test row
ab 1
a/b
abc
c/d 2
Please help
Thank you.
c/d 2