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