How about using the "OPTIONALLY ENCLOSED BY" parameter in your control file?
Would look something like this:
load infile ExportAll.txt
into table new_leads
insert
fields terminated by ','
optionally enclosed by '"'
(BusName,
SecName,
Address,
City,
State,
Zip4,
AreaCode,
PhoneNo)
David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com
-----Original Message-----
From: Ashish Shah [mailto:ar_shah_at_yahoo.com]
Sent: Friday, September 22, 2000 1:31 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Sqlldr help
Weaver this doesn't work.
I also tried this
load data
truncate
into table temp
fields terminated by "/"
(col1 ,
col2 ,
col3 ,
col4 ,
col5 ,
col6 ,
col7 ,
col8 ,
col9 ,
col10 ,
col11 ,
col12 ,
col13 ,
col14 ,
col15 ,
col16 ,
col17 ,
col18 ,
col19 ,
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,
>
> INFILE "/your_dir/your_file.csv" "str X'5c0a'"
>
> 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.
>
> --Walt
>
> -----Original Message-----
> From: Ashish Shah [mailto:ar_shah_at_yahoo.com]
> Sent: Friday, September 22, 2000 9:50 AM
> To: Weaver, Walt
> Subject: RE: Sqlldr help
>
>
> Hi Weaver,
>
> I have 8i.. could you explain more in "Str...".
>
> Thanks.
>
> --- "Weaver, Walt" <wweaver_at_rightnowtech.com> wrote:
> > What version of Oracle are you on?
> >
> > 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.
> >
> > --Walt Weaver
> > Bozeman, Montana, USA
> >
> > -----Original Message-----
> > From: Ashish Shah [mailto:ar_shah_at_yahoo.com]
> > Sent: Friday, September 22, 2000 9:26 AM
> > To: dbalist; lazydba
> > Subject: Sqlldr help
> >
> >
> > I have file format like below.. it's only big
> line..
> >
> > fields are seperated by '/' and '\' means end of a
> > record.
> >
> > What is the best way to load this file using
> sqlldr.
> >
> >
>
929827081384/QMSL/965821846858#216.10.166.52/1/7775/7775/0/0/0/1077.52499999
> > 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/CL
> > SL/9658
> >
>
7770775#63.76.159.204/1/22180/22180/0/0/0/1898.1949999965402/USD/96582786932
> > 8/5/
> >
> >
> > =====
> > Ashish
> > Toronto, Canada
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Send instant messages & get email alerts with
> Yahoo!
> > Messenger.
> > http://im.yahoo.com/
> >
> > --------
> > If you're bored, then visit the list's website:
> > http://www.lazydba.com
> > (updated daily)
> > to unsubscribe, send a blank email to
> > oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to
> oracledba-subscribe_at_quickdoc.co.uk
>
>
> =====
> Ashish
> Toronto, Canada
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo!
> Messenger.
> http://im.yahoo.com/
Ashish
Toronto, Canada
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ashish Shah
INET: ar_shah_at_yahoo.com
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 - 14:00:54 CDT