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
Printable View
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
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).