How to load tab delimited file - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: How to load tab delimited file

  1. #11
    Join Date
    Aug 2001
    Posts
    5
    I never actually tried it, but I found it in O'reilley's tip of the month category and if O'reilley put it there, I would say it works. But then again, nobody's perfect...

  2. #12
    Join Date
    Mar 2001
    Posts
    314
    Hey I did not say that it will not work - I simply said that you can load a TAB delimited file w/o explicity specifying it in hex - it works if we specify "FIELDS TERMINATED BY WHITESPACE".

    Sorry if I caused any confusion :(

    -amar

  3. #13
    Join Date
    Aug 2001
    Posts
    5
    Ahhhh, no big deal. I will also copy your example and save it with O'reilley's example. When the time comes for me to load a tab delimited file, I will now have 2 ways.

    Thanks,
    Joe

  4. #14
    Join Date
    Aug 2001
    Posts
    267
    Thanks for your methods .. I will try them . At this point I have to load ASAP ,so I used Power Builder to load . It is GUI and works on TAB delimited file . But it is very very slow .. No choice ..


    Raghu
    Raghu

  5. #15
    Join Date
    Aug 2001
    Posts
    5
    I was just speaking to a friend about this and there is ANOTHER way it can be done, and he's used it this way.

    FIELDS DELIMITED BY ' '

    In between the quotes, he has tabbed over 1 time. That's pretty logical.

  6. #16
    Join Date
    Aug 2001
    Posts
    267
    Thanks joe and Amar .. Both of your methods are working ..I tried terminated by whitespace as well as ' ' in between i tabed one time .. Both are working .. Next time my job will be faster since I am going to use SQL*LOADER with this idea's . it is taking forever from front end code reading and parsing the file ...

    Raghu
    Raghu

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