Shell Programming and Scripting

Hi,

I have two files to pick and excute these ones.

File1OLFIN.PRL_100.OIB.TLU.001.D20110510.T144948
File2OLFIN.PRM_100.OTU.001.D20100726.T050026


date '+%H:%M:%S'

SCRIPTS_PATH=/u/dolfin/bin
. ${SCRIPTS_PATH}/set_dolfin_env.sh
DATA_FILE_NAME=DATA_FILE
DATE_FORMAT=`date '+%Y%m%d'`
DATE_FORMAT=20110323
cd ${DOLFIN_IN_DIR}
# Try to get a data file matching the pattern and check if the data file exists or not

SAP_DATA_FILE=`ls DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU|OTU'`
if [ ! -z "${SAP_DATA_FILE}" ]
then
echo "Found SAP data file ${SAP_DATA_FILE}"
cd ${DOLFIN_BIN_DIR}
i=0
for file in /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU'
do
let i=i+1
SQL Load all the sap data from SAP_TUR into data management tables
sqlldr ${ORA_USER}/${ORA_PASSWD} control= /u/dolfin/bin/load_sap_credit_template.ctl bad=/u/dolfin/log/ data=$file
#move the processed data file to in_arc directory
mv $file ../in_arc
# Compress the data file
compress ../in_arc/$file
# echo $file archived
echo "Finished loading SAP data from TURKEY"
done
else
echo "No SAP data found for TURKEY!!!"
fi
date '+%H:%M:%S'



But getting error as

"load_sap_credit_data_oib_turkeynew1.sh[29]: syntax error at line 35 : `|' unexpected"

Reason is in the code
" for file in /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU' "

This is invalid.

Could you please let us know replacing correct stmt in place of above code.

Appricate early response on this

Hi,

Try something like this:

Code:

for file in $(ls -1 /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU')

Regards,
Birei

Pleas use code tags.

What shell are you using?
In bash, the correct syntax is:

Code:

for file in /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* ; do
   echo $file |  egrep -e 'TLU' 
   # do something else with $file
done

If you are trying to apply the grep filter on filenames, then

Code:

for file in `ls /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* |  egrep -e 'TLU' ` ; do
   echo $file 
   # do something else with $file
done