Hi,
I created the control file for a csv data file,in some of the rows the data for few columns has some junk character like NESPRESSO CAFÉ,in which É is a junk character and causing the row to fail with the error no terminator found after TERMINATED and ENCLOSED field
Can anyone suggest to load these rows also even though the data has some special characters.Following is my control file
OPTIONS(SKIP=1,ERRORS=100)
LOAD DATA
REPLACE
INTO TABLE <table_name>
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
column1,column2,----,columnn
)
Thanks,