Hi All,
I am using a sqlldr script to load data into staging table, I have a column called location as the last column in the csv file.
When I load this file using SQLLDR, there is an extra space at last in the location data inserted into the table. Note: Location is the last column in my table and file.
I have used TRIM function , but it seems to be not working.
Is there any options to trim the trailing white space from the last column of the file.
here is my sqlldr script
LOAD DATA
APPEND
INTO TABLE XXGDC_ADP_HR_STAGING
WHEN (file_number <> 'File #')
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
THROWAWAY FILLER,
FILE_NUMBER ":FILE_NUMBER",
POSITION_ID ":POSITION_ID",
LAST_NAME ":LAST_NAME",
FIRST_NAME ":FIRST_NAME",
MIDDLE_NAME ":MIDDLE_NAME",
HOME_DEPARTMENT_DESCRIPTION ":HOME_DEPARTMENT_DESCRIPTION",
HOME_DEPARTMENT_CODE ":HOME_DEPARTMENT_CODE",
JOB_CODE ":JOB_CODE",
JOB_TITLE_DESCRIPTION ":JOB_TITLE_DESCRIPTION",
REPORTS_TO_NAME ":REPORTS_TO_NAME",
HIRE_DATE DATE "MM/DD/RRRR",
TERMINATION_DATE DATE "MM/DD/RRRR",
ASSIGNMENT_START_DATE DATE "MM/DD/RRRR",
BADGE ":BADGE",
GENDER ":GENDER",
LOCATION "RTRIM(LTRIM(:LOCATION))",
ADP_HR_FILE_ID "$LOAD_IDENTIFIER",
FILENAME constant "$FILE_NAME",
FILE_LINE_NUMBER SEQUENCE(1,1),
RECORD_STATUS CONSTANT 'N',
CREATION_DATE "SYSDATE",
CREATED_BY "$USERID",
LAST_UPDATE_DATE "SYSDATE",
LAST_UPDATED_BY "$USERID",
LAST_UPDATE_REQUEST_ID "$REQID"
)
Thanks for you valuable time and help.
Thanks,
Ragul