Sql*Loader: Loading fields containing newlines from a data file

We have a data file containing the following records:

1|bla
bla
2|bla
bla

The table definition is as follows:

TABLE text

    key NUMBER(9)
    tekst LONG

We want to use SQL*Loader to load the data from the file into this table, but SQL*loader has problems with the newlines which are part of the data.

Also using ENCLOSED BY doesn't seem to work.

Does anyone out there have a solution. If nessecary, we can change the format of the data file.

Thanks in advance,

Peter. Received on Thu Aug 01 1996 - 00:00:00 CEST