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
    Posts
    115

    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?

    Thanks

    Sam

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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