-
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
-
Re: sql loader with new lines?
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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
--------------------------------
Mark Backhouse
Oracle Database Administrator
Great North Eastern Railways
York
UK
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|