quotes in sql loader

[aspdba]

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

[DaPi]

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