UNIX for Advanced & Expert Users

Wow Wow Wow!!!!!!!!
I Couldnt Say Anything... Awesome...
U R A Real Genius... Great And Thanks A Ton...
This Was Bugging Me For Last 3 Days... Great Relief... Thanks A Million :d

Hi Vgersh,

This command is working perfect in command line.

when i m using this code it gives an error "
awk: sum is not an array"

Can u please help. Sorry to bother you again. Thanks a lot!!

WORKING_DIR="/opt/apps/manu/custcpfr/temp/perl_poc"
OUTPUT_FILENAME="temp.dat"

ctlfile="test.ctl"
AGGR_VALUE=`grep ^AGGREGATE $ctlfile`

AGGREGATE=`echo $AGGR_VALUE | cut -f2 -d "=" | sed -e 's/^ //g'`

echo $AGGREGATE

if [ $AGGREGATE = "YES" ]
then
echo "Right"
fi

if [ $AGGREGATE = "YES" ]
then
`awk -F"|" '{ idx=$2 FS $3 FS $4 FS $5; sum[idx] += $7; first[idx]=$1;sixth[idx]=$6 } END { for (record in sum) printf("%s%s%s%s%s%s%s\n", first[record], FS, record, FS, sixth[idx], FS, sum[record]) }' $WORKING_DIR/$OUTPUT_FILENAME > $WORKING_DIR/$OUTPUT_FILENAME`

fi

sixth[name] and not sixth[idx].. sorry.. but still not working

Use
awk -F"|" '{ idx=$2 FS $3 FS $4 FS $5; sum[idx] += $7; first[idx]=$1;sixth[idx]=$6 } END { for (record in sum) printf("%s%s%s%s%s%s%s\n", first[record], FS, record, FS, sixth[idx], FS, sum[record]) }' $WORKING_DIR/$OUTPUT_FILENAME > $WORKING_DIR/$OUTPUT_FILENAME

without the "`".

I tried them...Still not working.

mike, code tags exist for a reason.

Dumping a bunch of code in a post without them is pointless, nobody will want to read you posts, and few will bother to try.

Hi I got it fixed.

As i m redirecting to the same file it was not working.
So i used outfile to get the result and used a mv command

awk -F"|" '{ idx=$2 FS $3 FS $4 FS $5; sum[idx] += $7; first[idx]=$1;sixth[idx]=$6 } END { for (record in sum) printf("%s%s%s%s%s%s%s\n", first[record], FS, record, FS, sixth[idx], FS, sum[record]) }' $WORKING_DIR/$OUTPUT_FILENAME > out
mv out $WORKING_DIR/$OUTPUT_FILENAME

Thanks for your help.