Re: SQLLoader: Tough question

I have been able to load data with quotes in the data value.

A sample value is : "this is a ""sample"" value". Look at the ""sample"" word in the quotes-enclosed value.

Verma

no spam <no_at_spam.com> wrote in article
<8%km4.1761$zr1.5181438_at_news.magma.ca>...
> In short NO.
>
> Some additional points that might help.
>
> Sqlldr allows a wide variety of delimiters but you have to use one that
is
> not contained in the data you are loading.
> The loader file must have this line to use " as a delimter
> enclosed by ' " '
> If you cannot get them to change it to this
> enclosed by " ' "
> Then your only option would be to use ' instaed of " in you data
>
>
> EnderW wrote in message <87c6bl$dve$1_at_nnrp1.deja.com>...
> >Hi,
> > this might not be a tough question but it is from my end. In one
> >sqlldr file, I have " and these are accepted by the sqlloader as the
> >ending of field. They are not. Is there an escape character I can put
> >in front of those '"' so that they will not be treated as field
> >delimiters but part of the field. Thanks
> >
> >
> > Note. I cannot change the sqlldr control file.
> >
> >--
> >Ender Wiggin
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>
>
Received on Sun Feb 06 2000 - 00:29:27 CST