Shell Programming and Scripting

Hi all,

I am using the SQL Loader in Oracle for my data loading.
So i create dynamic control script in unix. I replace the variables with input data in control file using the sed command. The sed commands works fine for the character data, but gives me error on the DATE value.

sed "s/\#BATCH_LOAD_ID\#/${BATCH_LOAD_ID}/
s/\#JOB_PROCESS_ID\#/${JOB_PROCESS_ID}/
s/\#EXTRACT_DATE_FROM\#/${EXTRACT_DATE_FROM}/
s/\#FILENAME\#/${FILENAME}/" $SCRIPTDIR/bulkloadctrl.ctl >> $WORKDIR/$CTLNAME.ctl

In the above, the problem comes for extract_date_from. I will be having the input as EXTRACT_DATE_FROM='08/09/2005 12:30'.

Here i get error saying that EXTRACT_DATE_FROM cant be parsed. I guess the problem is bcos of "/" available in my date format, as that is the control character in sed command. But i am not sure how to resolve it. I have tried using escape sequence "\", but i couldnt find solution. EXTRACT_DATE_FROM is passed as an Input parameter to the shell script.

Any help will be of great use to me.

Thanks,
Utham

before inserting the '08/09/2005 12:30' insert '\' so the input string should be:

'08\/09\/2005'