Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Loader 1

Status
Not open for further replies.

asb555

Programmer
Joined
Dec 19, 2000
Messages
37
Location
US
Hi Guys,
I am trying to load some data into Oracle using sql loader. The fields are separated by commas. The problem i'm having is that some of the fields have trailing whitespaces, which i don't want to load.

ex: John ,Michael,Thomas ,Henry

how can i do this using sql loader?

Thanks in Advance.
 
If I'm reading the SQL*Loader documentation correctly, it looks as if you will need to use the RTRIM function in your control file for each column that might have trailing blanks. Something like the following should work

field1 CHAR TERMINATED BY "," "RTRIM(:field1)"

 
Thanks karluk!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top