Shell Programming and Scripting

awk -f report products associates sales

awk: report:2: awk '/2008/{print $0}' sales > /tmp/newSales
awk: report:2:       ^ invalid char ' ' ' in expression

./report associates products sales

#! /bin/bash
awk '/2008/ {print $0}' sales > /tmp/newSales

declare -a names
declare -a totalsales
declare -a position

echo -e "Name:\tPosition:\tTotal Sales:"
ID=1
while [ $ID -le 6 ]
do
  awk /[2][$ID]$/ /tmp/newSales > /tmp/sales.2$ID
  let ID=$ID+1
done

GRANDTOTAL=0
ID=1
while [ $ID -le 6 ]
do
  while read line
  do
    PRODID=`echo $line|cut -d"," -f1`
    QUANT=`echo $line|cut -d"," -f2`
    PRICE=`awk /^$PRODID/ products|awk -F":" '{print $3}'`
    TOTAL=$(echo "scale=2; $PRICE*$QUANT" | bc)
    GRANDTOTAL=$(echo "scale=2; $GRANDTOTAL+$TOTAL" | bc)
done < "/tmp/sales.2$ID"

totalsales[$ID]=$GRANDTOTAL
NAMES[$ID]=`awk /^[2]"$ID"/ associates | awk -F"/" '{print $2}'`
position[$ID]=`awk /^[2]"$ID"/ associates | awk -F"/" '{print $4}'`

echo ${NAMES[$ID]}":"${position[$ID]}":"${totalsales[$ID]} >> /tmp/output.$$

GRANDTOTAL=0
let ID=$ID+1
done

sort -n /tmp/output.$$ | awk -F":" '{print $1 $2 $3}' #/tmp/output.$$

# removes all created files
rm /tmp/sales.2*
rm /tmp/newSales
rm /tmp/output.$$

#! /bin/bash
awk "/2008/ {print $0}" sales > /tmp/newSales

#! /bin/bash
awk "/2008/ {print $0}" sales > /tmp/newSales

$
$ # display contents of file "sales"
$
$ cat sales
2007 - line no. 1
2007 - line no. 2
2008 - line no. 1
2008 - line no. 2
2008 - line no. 3
2009 - line no. 1
$
$ # display contents of shell script "report"
$
$ cat report
#!/bin/bash
#
# Note that this is a *shell* script, and not an awk script.
# The shebang at line 1 makes this script run in bash shell.
#
awk '/2008/ {print $0}' sales > newsales
$
$
$ # now execute the shell script; note that "sales" need not be passed as argument
$
$ ./report
$
$ # check if it worked
$
$ cat newsales
2008 - line no. 1
2008 - line no. 2
2008 - line no. 3
$
$

awk '/2008/ {print $0}' sales > newsales

$
$ awk -f report sales
awk: report:6: awk '/2008/ {print $0}' sales > newsales
awk: report:6:     ^ invalid char ''' in expression
$

$
$ # show the contents of awk script "report.awk"
$
$ cat report.awk
#
# This, on the other hand, is an awk script, and not a shell script.
# There is no shebang at line 1 and this script can be invoked with
# the "-f" option of the awk command line.
#
/2008/ { print $0 }

$
$ # invoke "report.awk" with the "-f" option of awk
$ # note that we must pass "sales" file as the input
$
$ awk -f report.awk sales
2008 - line no. 1
2008 - line no. 2
2008 - line no. 3
$
$
$ # and if redirection is to be done, do it in the shell
$
$ awk -f report.awk sales > newsales
$
$ cat newsales
2008 - line no. 1
2008 - line no. 2
2008 - line no. 3
$
$