SQLLDR want double quotes in string

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.",

Should be:

Code:

---

....
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
...

---

What did I miss?

Isn't that what I already have?

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


Thanks,

P

Last chance...

Anyone have a different thought on this?

Thanks.

P

:)

Instead of using:

Quote:

---

FIELDS terminated by "," optionally enclosed by '"'

---

Try using a different terminator character (like '|') and code:

FIELDS terminated by '|'

And no 'quote problems.

:cool: