sql loader with new lines?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql loader with new lines?

  1. #1
    Join Date
    May 2003
    Location
    York, UK
    Posts
    6

    Question 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

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    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"

  3. #3
    Join Date
    May 2003
    Location
    York, UK
    Posts
    6

    Exclamation

    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
  •  


Click Here to Expand Forum to Full Width