If your data is always positionally located you could use:
col1 position (001:012),
col2 position (014:018),
....
col20 position (075:099)
in your sqlload control file.
ROR =AA=BF=AA
>>> ar_shah_at_yahoo.com 09/22/00 02:30PM >>>
Weaver this doesn't work.
I also tried this
load data
truncate
into table temp
fields terminated by "/"=20
(col1 ,
col2 ,
col3 ,
col4 ,
col5 ,
col6 ,
col7 ,
col8 , =20
col9 , =20
col10 ,
col11 ,
col12 ,
col13 ,
col14 ,
col15 ,
col16 ,
col17 ,
col18 , =20
col19 , =20
col20 terminated by "\"
)
but it doesn't accept "\" it's giving me
SQL*Loader-625: Multibyte character error in control
file. error.
Any ideas...
- "Weaver, Walt" <wweaver_at_rightnowtech.com> wrote:
> Sure. In 8i you can specify the line termination
> string. A typical entry in
> the sqlloadr control file would look like,
>=20
> INFILE "/your_dir/your_file.csv" "str X'5c0a'"
>=20
> This specifies where the file containing the data is
> located, and that each
> line is terminated by a "\" (hex 5c) followed by a
> newline (hex 0a). In your
> case, since the whole file is one line, you'd just
> use "str X'5c'", I
> believe.
>=20
> --Walt
>=20
> -----Original Message-----
> From: Ashish Shah [mailto:ar_shah_at_yahoo.com]=20
> Sent: Friday, September 22, 2000 9:50 AM
> To: Weaver, Walt
> Subject: RE: Sqlldr help
>=20
>=20
> Hi Weaver,
>=20
> I have 8i.. could you explain more in "Str...".
>=20
> Thanks.
>=20
> --- "Weaver, Walt" <wweaver_at_rightnowtech.com> wrote:
> > What version of Oracle are you on?=20
> >=20
> > You can use the 'fields terminated by "/", and if
> > you're on 8i you can use
> > "Str X'5c0a'" on the INFILE line, or somesuch, to
> > specify the line
> > terminator.
> >=20
> > --Walt Weaver
> > Bozeman, Montana, USA
> >=20
> > -----Original Message-----
> > From: Ashish Shah [mailto:ar_shah_at_yahoo.com]=20
> > Sent: Friday, September 22, 2000 9:26 AM
> > To: dbalist; lazydba
> > Subject: Sqlldr help
> >=20
> >=20
> > I have file format like below.. it's only big
> line..
> >=20
> > fields are seperated by '/' and '\' means end of a
> > record.
> >=20
> > What is the best way to load this file using
> sqlldr.
> >=20
> >
>
929827081384/QMSL/965821846858#216.10.166.52/1/7775/7775/0/0/0/1077.5249999=
9
> > 5716/USD/965827868940/100/3/F/300////0/1B-
> > -RN-26584356\963404816559/MNKN/965827167
> >
>
777#172.153.170.192/1/850/0/0/0/0/1558.14999999708/USD/965827869212/25/1/F/=
2
> >
>
5/7/11-13-5-10-30-29-39/$$/0/1-30-9-21-36-19-22-25-7-33-28-0\961264536939/C=
L
> > SL/9658
> >
>
7770775#63.76.159.204/1/22180/22180/0/0/0/1898.1949999965402/USD/9658278693=
2
> > 8/5/
> >=20
> >=20
> > =3D=3D=3D=3D=3D
> > Ashish
> > Toronto, Canada
> >=20
> > __________________________________________________
> > Do You Yahoo!?
> > Send instant messages & get email alerts with
> Yahoo!
> > Messenger.
> > http://im.yahoo.com/=20
> >=20
> > --------
> > If you're bored, then visit the list's website:
> > http://www.lazydba.com=20
> > (updated daily)
> > to unsubscribe, send a blank email to
> > oracledba-unsubscribe_at_quickdoc.co.uk=20
> > to subscribe send a blank email to
> oracledba-subscribe_at_quickdoc.co.uk=20
>=20
>=20
> =3D=3D=3D=3D=3D
> Ashish
> Toronto, Canada
>=20
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo!
> Messenger.
> http://im.yahoo.com/=20
=3D=3D=3D=3D=3D
Ashish
Toronto, Canada
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/=20
--=20
Please see the official ORACLE-L FAQ:
http://www.orafaq.com=20
--=20
Author: Ashish Shah
INET: ar_shah_at_yahoo.com=20
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
Received on Fri Sep 22 2000 - 13:49:32 CDT