Hi All,
I have a csv file of following format:
1,"abcdef",01-JAN-2014
2,"gh"i"jk",02-JAN-2014
3,"lm,no,pq",03-JAN-2014
4,"rst'uvw'xyz",04-JAN-2014
Now my sqlloader control file looks like this:
LOAD DATA
TRUNCATE
INTO TABLE TEST_LOAD
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(test_col1,
test_col2,
test_col3)
This gives following error:
1. no terminator found after TERMINATED and ENCLOSED field - (test_col2 for second row data)
2. If OPTIONALLY ENCLOSED BY '"' is not used - then sql loader will try to insert 'no' in 3rd row into date which throws error
3. Used replace option like - test_col2 "replace(:test_col2,'\"','-')" and this also gives no terminator found after TERMINATED and ENCLOSED field error.
Please help me in resolving this issue by changing in loader script. CSV file should not be changed.
Thanks,
Balaji