Error with redirection

Question

I'm trying to find average of values in 2nd column in some files. Filenames have following pattern eg:

tau_2.54_even_v1.xls
tau_2.54_odd_v1.xls
tau_1.60_v1.xls
tau_800_v1.xls

The other filenames can be obtained by replacing variable file with oter variables pmb , xhpl etc .. Here is the script I've written .. Can anyone kindly find the error and let me know ?

#!/bin/bash
for file in pmb_mpi tau xhpl mpi_tile_io fftw ; do
    for f in "2.54" "1.60" "800" ;do
    if [ ${f} = 2.54 ]
    then 
        for order in even odd ; do
        echo ${file}_${f}_${order}_v1.xls
        awk 'sum+=$2 ;END {print "Average = " , $sum/NR > ${file}_${f}_${order}_avrg.xls }' ${file}_${f}_${order}_v1.xls
        done
    else
        echo ${file}_${f}_v1.xls 
        awk 'sum+=$2 ;END {print "Average = " , $sum/NR > ${file}_${f}_avrg.xls }' ${file}_{f}_v1.xls
    fi

    done
done

Dennis Williamson · Accepted Answer · 2009-12-01 07:21:19Z

2

One problem I see right away is that you have a dollar sign with the variable "sum" in your awk scripts.

Change it to remove the dollar sign. One of the lines would then look like this:

        awk 'sum+=$2 ;END {print "Average = " , sum/NR > ${file}_${f}_${order}_avrg.xls }' ${file}_${f}_${order}_v1.xls

answered Dec 1, 2009 at 7:21

Dennis Williamson

364k95 gold badges386 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sharat Chandra Over a year ago

Thanks for correcting that error. The error seems to be in the awk command.. When I commented the awk commands, the script did not show any errors .

martin clayton · Accepted Answer · 2009-12-01 07:26:40Z

2

In the else clause you've missed a dollar sign in the input file name to awk.

#-------v----------
${file}_${f}_v1.xls

answered Dec 1, 2009 at 7:26

martin clayton

78.6k33 gold badges220 silver badges201 bronze badges

1 Comment

Sharat Chandra Over a year ago

Thanks for correcting that error. But the error seems to be in the awk command.. When I commented the awk commands, the script did not show any errors .

sud03r · Accepted Answer · 2009-12-01 07:37:36Z

2

If your xls files are spreadsheets, i dont think you can normally read them using awk. You should convert xls to some convinient file format like csv using a perl module here:

http://search.cpan.org/~ken/xls2csv/script/xls2csv

And now you can use awk over that csv file.

answered Dec 1, 2009 at 7:37

sud03r

20k17 gold badges80 silver badges96 bronze badges

Comments

Sharat Chandra · Accepted Answer · 2009-12-02 06:44:07Z

0

I got my answer. Here is the code

#!/bin/bash

for file in pmb_mpi tau xhpl mpi_tile_io fftw ; do

for f in 2.54  1.60 800 ; do

if [ ${f} = 2.54 ]
then 
    for order in even odd ; do

printf "\n${file}${f}${order}_v1.xls " >> Safe/P-state-summary.xls

    awk '{sum+=$3}; END  {print "\n${file}_${f}_${order}_v1.xls  " sum/NR}' ${file}_${f}_${order}_v1.xls >> Safe/P-state-summary.xls
    done
else

printf "\n${file}_${f}_v1.xls " >> Safe/P-state-summary.xls

    awk '{sum+=$3}; END  {print"\n${file}_${f}_v1.xls "  sum/NR}' ${file}_${f}_v1.xls >>  Safe/P-state-summary.xls
fi
done

done

There were problems wit redirection of awk output . Thank you all for your valuable suggestions

edited Dec 2, 2009 at 6:44

answered Dec 1, 2009 at 9:26

Sharat Chandra

4,5848 gold badges52 silver badges69 bronze badges

Collectives™ on Stack Overflow

Error with redirection

4 Answers 4

1 Comment

1 Comment

Comments

printf "\n${file}${f}${order}_v1.xls " >> Safe/P-state-summary.xls

printf "\n${file}_${f}_v1.xls " >> Safe/P-state-summary.xls

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

printf "\n${file}${f}${order}_v1.xls " >> Safe/P-state-summary.xls

printf "\n${file}_${f}_v1.xls " >> Safe/P-state-summary.xls

Comments

Your Answer

Sign up or log in

Post as a guest

Related