Re: Record delimiter in SqlLoader

Daniel,
I don't think this is what the OP is asking for. But then he did not specify an example.....

TurkBear,
Does the datafile look like this:

1,2,3|4,5,6|7,8,9|10,11,12|

where each record is delimited by a '|'
....

or does it look like this:

1,2,3|
4,5,6|
7,8,9|

or does it look like this:
1,2,3,|
4,5,6,|
....

or ....

?????

Though you thought you were clear ... but not really. Also .. what OS? maybe you can use sed/perl/... to "prepare" the data.

Anurag

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D542A19.E78AB16C_at_exesolutions.com...
> TurkBear wrote:
>
> > Hi,
> > Is there a way to specify a record delimiter in a Sql Loader input file.
> > I can specify the field delimiter with the 'terminated by optionally
enclose by' syntax, but how to I tell it
> > that the record ends with something other than a CR/LF ( or NewLine)
character?
> > ( Like a | for instance)
> >
> > Thanks,
> >
> >
> > -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> > http://www.newsfeed.com The #1 Newsgroup Service in the World!
> > -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=-----
>
> A typical control file might look like this:
>
> LOAD DATA
> INFILE *
> INTO TABLE dept
> FIELDS TERMINATED BY ','
> OPTIONALLY ENCLOSED BY '"'
> (deptno, dname, loc)
>
> Change the fields terminated by to '|'
>
> and you have what you want.
>
> Daniel Morgan
>
Received on Fri Aug 09 2002 - 23:20:28 CEST