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
--------------------------------
Mark Backhouse
Oracle Database Administrator
Great North Eastern Railways
York
UK