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
Re: sql loader with new lines?
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.