Re: SQLoader and CR/LF
From: bob sullivan <bsullivn_at_home.com>
Date: Fri, 17 Aug 2001 01:20:26 GMT
Message-ID: <3B7C7186.B39EE590_at_home.com>
Date: Fri, 17 Aug 2001 01:20:26 GMT
Message-ID: <3B7C7186.B39EE590_at_home.com>
My kneejerk reaction to this problem would be to write a Perl script to scrub the data before trying to feed it to SQL*Loader.
~bob
Jacek Pichla wrote:
> 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 Fri Aug 17 2001 - 03:20:26 CEST