Re: SQLoader and CR/LF
Date: Thu, 16 Aug 2001 07:51:54 -0700
Message-ID: <tnnngjt3ircs3c_at_corp.supernews.com>
Jacek,
I had the same trouble a while back, and the only suitable answer I discovered was the "str" directive for the INFILE command. And I was only able to use this because my data was fairly regular at the termination point (I had a semi-colon right before the NL/CR).
So, in my control file, I had something like:
INFILE "MyFile" "str X'3B0A'"
I don't know if that's applicable for you, but it might be something to investigate.
Good luck!
John Peterson
"Jacek Pichla" <jpichla_at_wp.pl> wrote in message
news:9lfu6n$q0c$1_at_news.tpi.pl...
> Hi
>
> Please anybody tell me how to import string data by means of SQLLoader
in
> which the the newline character is included.
> The line in a text file looks like below:
>
> 10, 001, "The line which includes
> newline character", 1998
>
> I tried to use CONTINUEIF 0x0A or 0x0D but SQLoader doesnt take it.
>
> Thanks in advance
>
> --
> Jacek Pichla
>
>
Received on Thu Aug 16 2001 - 16:51:54 CEST