sqlldr question: data continue by "\"

From: Ed Wong <ewong_at_mail.com>
Date: 13 Aug 2002 11:31:35 -0700
Message-ID: <a5ae1554.0208131031.724e274b@posting.google.com>

I have a flat file delimited by "tab" and I need to load it into a three-column table where the 3rd column is a clob. The problem is the 3rd colum in the flat file is continue by "\" (see below). How do I get this data in using sqlldr? I tried (continueif this = "\") but appearantly sqlldr doesn't like it.

Thanks in advance.
ewong

1 IPR000001 Kringles are autonomous structural domains, found throug

hout the blood                clotting and fibrinolytic proteins.\

Kringle domains are believed to play a role in binding mediators
(e.g., membrane

s,\
[<a href="http://www.ncbi.nlm.nih.gov/htb in-post/Entrez/query?uid=84208845&form=6&db=m&Dopt=b">MEDLINE: 84208845</a>], [<
a href="http://www.ncbi.nlm.nih.gov/htbin-post/Entrez/query?uid=90219023&form=6& db=m&Dopt=b">MEDLINE: 90219023</a>]. \
<img src=http://www.sange
r.ac.uk/Software/Pfam/gifs/betachar.gif width=12 height=10>-sheet. They are foun
d in a varying number of copies, in some serine proteases and\ plasma proteins.\
\

control file:
load data
infile file.dat"
into table table_name
fields terminated by X'09'
trailing nullcols
(

auto_interpro integer external,
interpro_id char,
interpro_abstract char) Received on Tue Aug 13 2002 - 13:31:35 CDT