Shell Programming and Scripting

Hi Gurus,

My requirement is, I am passing a file1.dat into this(rowcnt.sh) script,but returning a wrong value of -2.(it should be 4).Becoz my file1.dat contains 6records incl: Header & Footer.(6-2=4)

wrong output:
-------
#sh rowcnt.sh file1.dat
-2 actual_cnt except HDR & FTR

should be:
-------
#sh rowcnt.sh file1.dat
4 actual_cnt except HDR & FTR

my script:
=======
rowcnt.sh
-------
PARA1=$1 #input_file file1.dat
SOURCE_FILE_NAME=`echo ${PARA1}`
ACTUAL_CNT=`wc -l $SOURCE_FILE_NAME` # Count records in the data file
ACTUAL_CNT1=`$ACTUAL_CNT |awk -F ' ' '{print$1}'`
ACTUAL_CNT2=$ACTUAL_CNT1-2 # total no of records-2(Hdr & Ftr)
echo $ACTUAL_CNT2 "actual_cnt except HDR & FTR"
exit 1
--------------------------------------------------

Pl advise.Bit urgent. Thanks a lot....

you have posted in the wrong forum

this thread needs to be moved

any way try this,

Code:

awk '{}END{ print NR - 2 }' filename

Modified your code

rowcnt.sh
-------

Code:

PARA1=$1 #input_file file1.dat
SOURCE_FILE_NAME=`echo ${PARA1}`
ACTUAL_CNT=`wc -l $SOURCE_FILE_NAME` # Count records in the data file
ACTUAL_CNT1=`echo $ACTUAL_CNT |awk '{print $1}'`
ACTUAL_CNT2=$((ACTUAL_CNT1-2)) #total no of records-2(Hdr & Ftr)
echo $ACTUAL_CNT2 "actual_cnt except HDR & FTR"
exit 1

or you can use like

Code:

PARA1=$1 #input_file file1.dat
SOURCE_FILE_NAME=`echo ${PARA1}`
ACTUAL_CNT=`awk 'END{ print NR -2}' $SOURCE_FILE_NAME`
echo $ACTUAL_CNT "actual_cnt except HDR & FTR"
exit 1

Great all,

It works great....

Thks...........