Re: SQLLDR contrl file syntax question

I think the following will work, unfortunately I couldn't test it :

LOAD DATA
INFILE 'c:\test\test.dat'
INTO TABLE tblTest
REPLACE
WHEN POSITION(1:3) = '876'
FIELDS TERMINATED BY ',' optionally enclosed by '"' ( relevantInfo CHAR

   otherInfo CHAR
)

INTO TABLE tblTest
REPLACE
WHEN POSITION(1:4) = '"876'
FIELDS TERMINATED BY ',' optionally enclosed by '"' ( relevantInfo POSITION(1) CHAR

   otherInfo CHAR
)
Received on Thu Jun 05 2003 - 08:18:50 CDT