Re: sqlldr: how to ingore spaces in source file?

From: Chris Leonard <s_p_a_m_chris_at_hotmail.com>
Date: Thu, 1 May 2003 13:46:02 -0500
Message-ID: <1Ydsa.41$tL4.33629@news.uswest.net>

In your control file, specify that the data uses the string ' | ' as a delimeter. For example:

<snip>

LOAD DATA
INFILE *
APPEND
INTO TABLE XYZ
FIELDS TERMINATED BY " | " OPTIONALLY ENCLOSED BY '"' </snip>

You'll need other bits in the control file, but it seems like this is the key piece for you.

-- 
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"Ed Wong" <ewong_at_mail.com> wrote in message
news:a5ae1554.0305011011.7d5bdc5b_at_posting.google.com...


> Hi,

>

> I need to use sqlldr to load into a 3 column tables from a flat file.

> The flat file looks like below.  There are spaces within column.  How

> can I tell sqlldr to ignore/trim the spaces in front and after the

> data?

>

> 1       |       all     |       synonym

> 2       |       Bacteria        |       Bacteria <bacteria>

>

> Thanks,

> ewong

Received on Thu May 01 2003 - 13:46:02 CDT