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

goyal wrote:

> 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... ?

If I understand the problem correctly.

Use the quotes in the extract and the following SQL*Loader control file keyphrase:
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' Modify your extract program to put quotes around alphanumeric fields, e.g.

123|0.12|This is some text|"This a text with a | symbol"|Y|123.45
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
                       enclosed with quotes, treated as a single column

--
Billy