SQL*Loader : How to load data that contains delimiter?

Hi,

Am sorry if my question sounds bit weird...

Wit SQL*Loader, is there a way to ignore delimiter in some way? We are using '|' as delimiter and there is a special column, data for which contains '|'....

Can one specify some special character like '|' or '\' before delimiter and then, delimiter will be treated as simple data... ?

Will change our extract program if this is possible.

Thanks,
Sachin Received on Mon Feb 17 2003 - 21:23:18 CST