Hello,

I have to load a flat file with a column wich can contain carriage return(0d0a) on windows platform ; I've tried the option STR but sql*loader ignore this (SQL*Loader-283); how can i load these characters ?
Thanks

LOAD DATA
INFILE * "STR X'0d0a'"
APPEND
INTO TABLE TRB_EDS_TECHNIQUE
FIELDS TERMINATED BY ';' ENCLOSED BY '"'
TRAILING NULLCOLS
(
EDS_ID CHAR(30), -- FIELD TYPE=VARCHAR2 PK=True
ETE_ACCEPTATION , -- FIELD TYPE=NUMBER PK=False
ETE_ALERTE , -- FIELD TYPE=NUMBER PK=False
ETE_COMM_CONTRAINTE CHAR(1000), -- FIELD TYPE=VARCHAR2 PK=False
ETE_CONTRAINTE , -- FIELD TYPE=NUMBER PK=False
ETE_DATE_DIFFUSION date(19) 'YYYY-MM-DD HH24:MIS', -- FIELD TYPE=DATE PK=False
ETE_DIFFUSION , -- FIELD TYPE=NUMBER PK=False
ETE_MANUEL , -- FIELD TYPE=NUMBER PK=False
ETE_SUIVI_HNO , -- FIELD TYPE=NUMBER PK=False
ETE_TRAITE , -- FIELD TYPE=NUMBER PK=False
ETE_TYPE , -- FIELD TYPE=NUMBER PK=False
TPO_ID CHAR(10) -- FIELD TYPE=VARCHAR2 PK=True
)
BEGINDATA
"00XMOAT1";"1";"1";"testggg";"1";;"1";"0";"1";"1"; "2";"0407000049";
"00XDRSA";"0";"1";"C'est laaa";"1";;"1";"1";"1";"1";"1";"0407000049";
"00XDRSA1";"1";"1";"testuuuu";"1";;"1";"1";"1";"1" ;"1";"0407000049";
"00XRIG";;"1";"test";"0";;"0";"0";"0";"0";"1";"040 7000049";
"00XX03T2";"0";"1";"test";"2";;"1";"0";"1";"0";"1" ;"0407000049";
"00XX04";;"0";"123456789
123456789
123456789
123456789
123456789
123456789
123456789
HHHH";"3";;"1";"1";"1";"1";"2";"0407000049";