Unable to load data from CSV file using SQL Loader (Control File) when columns value having carriage

Hi All,

Problem : Unable to load data from CSV file using SQL Loader (Control File) when columns value having carriage return/line feed characters.

Any help would be appericiated!!

My Control file as below:

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
OPTIONS (SKIP = 1)
LOAD DATA
INFILE p_file_name
APPEND
-- CONTINUEIF LAST ='"'
-- Populate data from CSV File for Objective Library
INTO TABLE COLN.COL_LIBRARY_OBJECTIVE
-- WHEN p_type='Objective Library'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(OBJECTIVE_NAME   CHAR(400) "REPLACE(REPLACE(TRIM(:OBJECTIVE_NAME),CHR(10),''),CHR(13),'')",
 VALID_FROM   DATE "DD-MON-YYYY HH24:MI",
 VALID_TO   DATE "DD-MON-YYYY HH24:MI",