Results 1 to 3 of 3

Thread: SQLLoader

  1. #1
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421

    Unanswered: SQLLoader

    *SIGH* You guys are pretty much my last resort.

    I have a CSV file that i want to upload (automated) using SQLLoader.
    This file looks like:
    22222,5,yyyy,"Something, Anotherthing",543, N, F

    TO the naked eye it looks like there are 7 fields, the loader how ever makes it into 8. It splits the " " part as well because there is a , in there.

    How can i make SQLLoader accept the " "ed part as 1 field ignoring the ,??

    Regards & TIA

    One Desperate Mailman

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    use:

    OPTIONALLY ENCLOSED BY '"'

    in the FIELDS part of the control file

  3. #3
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    I had a "EUREKA" when i woke up this morning and got it working even before opening my mail

    Thanks for your response tho, its nice to know that there are people out there willing to help

    I try and pitch in my 2 cents when i can...

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •