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