RE: strip out characaters during sqlldr

I don't think you can use SQL in sqlloader and have it be a direct load in Version 8. The poster asked for Version 8/9 direct load.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Moss
Sent: Wednesday, March 07, 2007 5:54 AM
To: Oracle-L_at_FreeLists.org
Subject: RE: strip out characaters during sqlldr  

You just need to enclose an sql string function in double quotes (see example), obviously you will need replace or somesuch rather than what i've put there  

David.  

LOAD DATA
INFILE 'new_employees.csv'
INTO TABLE TEMP_EMP
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(

   LAST_NAME                        "decode(substr(:last_name, 0, 20), '',
null, substr(:last_name, 0, 20))"
 , TITLE                            CHAR NULLIF (TITLE=BLANKS)

..

)    

--
http://www.freelists.org/webpage/oracle-l