Hello All,

What is the proper way to code a control file (or my data) so that I can include a double quote with the data? I'm erroring out right now.

Below is a sample.

Thanks,

P

Control file
============
load data
infile test.dat
REPLACE
into table test
FIELDS terminated by "," optionally enclosed by '"'
(TEST_PK
,TEXT
)


Data file
=========
"15","If you answered "Yes," to any of the above, please provide details on a separate sheet.",