sql loader with new lines?

Hi all!

This is my first ever post :)

Basically I have a file that I am trying to load into a 9.2 database and one of the fields sometimes has new lines in it but that field is always encased in double quotes and each record is terminated with a newline. E.g.

test.csv

123456,12/06/98,Durham,"Notes on this incident.
Under further Investigation."
123457,12/06/98,York,"Investigated - No Further Action."

I have tried FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' but it doesn't like it.

Is it possible to load a file with newlines in a field?

Any help will be gratefully appreciated.

Thanks,
Mark

Quote:

---

Originally posted by markbackhouse
Basically I have a file that I am trying to load into a 9.2 database and one of the fields sometimes has new lines in it but that field is always encased in double quotes and each record is terminated with a newline. E.g.

test.csv

123456,12/06/98,Durham,"Notes on this incident.
Under further Investigation."
123457,12/06/98,York,"Investigated - No Further Action."

Any help will be gratefully appreciated.
Mark

---

Check this link...might me helpful to you.

Assembling Logical Records from Physical Records

And also

Case Study 4: Loading Combined Physical Records

Abhay.

Hi

Sorry for taking so long to reply - was waiting for an email to tell me when I had any replies to my post. Anyway, just read it so will read the oracle docs links and let you know how I get on.

Thanks again.

Mark