Re: Using SQL*Loader to load a comma delimited file

Sorry, how can loader determine where one field ends and another field starts?

If you can rebuild the data file, you should enclose the offending (text) fields in double quotes (") so your data file entry would look like:

-1001652147,"Farm, A - Pvt Practice",415 PIER AVENUE,,MANHATTAN BEACH,90254,CA,310 5691249,Pvt Practice

then in the control file use:
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' This is a double quote (") enclosed in single quotes (') like ' " '

Other than this, I think you're stuck.

--
Regards Pete
sanjay.raj_at_roche.com wrote in message <70nr7q$9dv$1_at_nnrp1.dejanews.com>...
>I have a comma delimited flat file ( having 1 million records). Some of the
>fields have a comma(,) as data too.
>
>The control file looks like
>
>load data
>infile "/home/rajs/NPECMAP.TXT"
>into table NPECMAP
>fields terminated by ','
>(Field1,field2,.....,field9)
>
>One record is
>
>-1001652147,Farm, A - Pvt Practice,415 PIER AVENUE,,MANHATTAN
>BEACH,90254,CA,310 5691249,Pvt Practice
>
>Here "Farm, A - Pvt Practice" is a single field (field2) and has a comma(,)
as
>data. How is it possible to load. I know we can load by changing the
delimiter
>but HOW CAN I LOAD WITHOUT CHANGING THE DELIMITER.
>
>Thanks
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Oct 23 1998 - 09:09:40 CDT