SQL Loader Character " issues
Hi All,
I have csv data file with comma separated and using Optionally enclosed " to load this data (fields terminated by "," OPTIONALLY ENCLOSED BY '"')
For one column (Description) i have data like this below and loader is failing with error
Record 3762: Rejected - Error on table XXPAG.XXPAG_FA_DEPRN_PRO_STG, column DESCRIPTION.
no terminator found after TERMINATED and ENCLOSED field
--Description Data examples
199.5"FSV Mast,72" Fork,S/S Fork Positioner, Diesel, Peuma
Laptop HP - 19"
Can someone pls help me in fixing this. I tried checking online and need expert advise here.