quotes in sql loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: quotes in sql loader

  1. #1
    Join Date
    Aug 2002

    quotes in sql loader

    I have a data file like mentiond below

    1,"a1","a2 "post a1,pre a3" it is",2

    I have string in quotes within quotes.

    Is it possible to insert this file into a table using sqlloader?



  2. #2
    Join Date
    Nov 2002
    Geneva Switzerland
    I don't think so.

    If you can control where it is generated, choose a different character to enclose the strings (I like using the circumflex: ^).

    If not, you'd have to edit the file globally replacing ," and ", with ,^ and ^, respectively (perhaps allowing for spaces).

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