sqlloader question

[badrinathn]

Hi,

I have a datafile which is comma delimited. However, some description feild have a comma which is enclosed with "," (double quotes).

My problem is while loading the data for the field (description fields) which have both comma and also double quotes.

ex

EU01,Part001,"This is a part for PC"," print "A","This is a part for PC"," print "A"


How can I load this data into my staging tables.
Region
Partnum
Descript...


badrinath

[badrinathn]

The data is
EU01,Part001,"This is a part for PC"," print "A"."

The above is for Region, Partnum and description.

The description to be loaded should appear as

"This is a part for PC, Print "A"."

My earlier posting got messed up while trying to Highlight the description field.


How should the control file look.
Current control file is :

LOAD DATA
INFILE '/u01/dataload/AP02/AP02-INVT000008.csv'
BADFILE '/u01/dataload/AP02/log/AP02-INVT000008.bad'
DISCARDFILE '/u01/dataload/AP02/log/AP02-INVT000008.dis'
TRUNCATE
INTO TABLE stg_ap02_inv_master
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(
Region_code,
PRC,
Part_desc)

Badrinath