SQL*Loader: How to load fields delimited by multiple characters instead of single character

From: Tom Warkentin <tom.warkentin_at_shaw.wave.ca>
Date: 24 Aug 1998 12:22:48 -0700
Message-ID: <01bdcf8c$35819de0$ab06010a_at_pluto.corenet.com>



Hi,

We have a file that contains many records on a single line (i.e. no new lines in between) and the fields in each record are delimited by strings (e.g. "XYZ" and "ABC"):

John DoeXYZ1998/08/01ABCJane SmithXYZ1998/08/05ABCJack Smith ...

Is there a way to specify to SQL*Loader fields delimited by strings? Or should the file be massaged by, for example, a perl script before using SQL*Loader? Ideally, it would be simpler for us if it could all be done by SQL*Loader since the data files are very large ... anyone have any ideas?

Thanks,
Tom Received on Mon Aug 24 1998 - 21:22:48 CEST

Original text of this message