I'm having trouble figuring it out, How do I create the control file when the next column data is also found in the first column of the comma delimited file.

Using this example, how will the control file look like.


Thanks,

Ed

--City_State Table
City varchar2(9)
St varchar2(2)
Ctry varchar2(3)

--Data(comma delimited)
GREENVILLSC,USA
STPAUL MN,USA
CHICAGO IL,USA
FREMONT NE,USA

--control file
----FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(City "substr(:City, 1,9)",
St "substr(:City,10,11)",
Ctry
)