sql*loader fixed width column / variable length record

im trying to figure this out. i have a datafile with the following records

tony sometext 120121122
mark sometext2 120
ethan sometext3 124125126

the format is:
name POSITION (1:8) char,
textstring POSITION (9:19) char,
code POSITION (20:22) char

the problem is, we could have multiple 3character codes in a single data record. i want to load each code as a separate database record with the same name and text fields.

However, i cant figure out how to get sql*loader to iteratively

 check if another 3character code exists in the current data record    (insert into table ...)

seems a fairly simple thing to do...

any ideas anyone?
-tone
ps. the data positions might be off.. but you get the idea Received on Wed Jan 08 2003 - 08:59:52 CST