Re: SQLLDR problem

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 18 Jul 2008 06:36:08 GMT
Message-ID: <1216362967.862368@proxy.dienste.wien.at>


Maxim Demenko <mdemenko_at_gmail.com> wrote:

> blindsey schrieb:

>> I'm trying to import a fixed-length ASCII file using SQLLDR.
>>
>> The end-of-line is 0D 0A, as usual.

"As usual" is funny.

>> But some notes fields in the data use 0D 0D 0A within them. SQLLDR
>> interprets this as end-of-line.
>>
>> Is there a way I can tell SQLLDR to ignore that sequence or translate
>> it into something else (like a space)?
>
> Fixed record format?

Or surround the fields with quotes.

Yours,
Laurenz Albe Received on Fri Jul 18 2008 - 01:36:08 CDT

Original text of this message