SQL*Loader and Double Quotes

From: Angus Tracy <angus.tracy_at_ntlworld.com>
Date: 4 Mar 2003 02:11:19 -0800
Message-ID: <f22fbfbc.0303040211.169e67d4@posting.google.com>

I'm having problems loading data containing double quotes using SQL*Loader.

For example, in the following two lines of my data file, the second one is being rejected.

AB3019A2,"CAMBRIDGE ROAD"
GR7013B5,"NEXT TO THE"RED LION"" I've tried a few things already, including using the REPLACE function as shown in the control file below, but not had much success. Does anyone have any suggestions ?

OPTIONS (DIRECT=FALSE,SKIP=3,READSIZE=1000000,ERRORS=1000000,BINDSIZE=1000000,ROWS=1000,SILENT=(ALL)) LOAD DATA
REPLACE
INTO TABLE RAW_ADDRESS
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(S_REF CHAR
,STREET CHAR "REPLACE(:STREET, CHR(34))" ) Received on Tue Mar 04 2003 - 04:11:19 CST