So...let me get this right. You
1) told us we missed something ('He had two double-quotes rather than a single double-quote') when we didn't, because his data DOES contain embedded *repeated* double quotes.
2) suggested an alternative answer ('If using only 1 single quote would likely have
fixed his problem') which you didn't validate
3) if you *had* tested it, you'd see it was wrong
LOAD DATA
INFILE *
TRUNCATE
INTO TABLE dataxxl
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' <== your suggestion
TRAILING NULLCOLS
(
field1 "LTRIM(RTRIM(:field1,chr(34)),chr(34))",
field2 "LTRIM(RTRIM(:field2,chr(34)),chr(34))",
field3 "LTRIM(RTRIM(:field3,chr(34)),chr(34))"
)
BEGINDATA
"991-xxxxx,""CSW xxxx, DATED xxxxx"",0xxx31"
C:\temp>sqlldr control=x.ctl userid=mcdonac/*******
SQL*Loader: Release 12.2.0.1.0 - Production on Thu Dec 14 15:59:35 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Path used: Conventional
Commit point reached - logical record count 2
Table DATAXXL:
0 Rows successfully loaded. <==== Nope
and yet *we* are the ones that get 1 star review for providing an answer that was correct.
Not sure how that logic works ... but well, there you go.
Merry Christmas to us I suppose