SQL*Loader questions

Hi,

My datafiles are delimited, e.g. by |

(1) How do I make a field of four blank spaces, enclosed by delimiters,
to be loaded as a NULL instead of four spaces?

(2) How do I make the last field, if it starts with a delimiter and does
not contain anything but a carriage return, to load a NULL instead of a carriage return? (I believe this was what happened). e.g., the following has four columns, the last one is supposed to be a null column, i.e. after the last delimiter:

first field|second field|third field|
first field|second field|third field|

Thanks in advance,

Jerome. Received on Sun Dec 12 1999 - 23:44:26 CST