Shell Programming and Scripting

[Number] [Surname] [Name] [Cubic] [Price] [Date when bought car] [Model]

NBE3452 PANAGIWTOY NIKOLAOS 1200 20000 12/05/2008 BMW
TKH2345 VAFEIADIS GEWRGIOS 1400 23400 09/5/2007 BMW
TKE3423 STYLIANOY DHMHTRA 1800 14000 23/11/2006 FIAT
NTN7800 MARKOY KWNSTANTINOS 2300 34000 23/12/2008 FIAT
PIN1245 KARAGEWRGIOY EYAGGELOS 1800 23000 11/5/2009 GOLF
NKN4200 MARGARITH STAYROULA 1200 19000 22/5/2009 BMW
KNB4506 KALPAKIS NIKOLAOS 1400 23000 30/7/2008 BMW
XKA9128 MYLWNAS HLIAS 1600 21000 12/9/2008 AUDI

#!/bin/sh

if [ $# -ne 1 ]; then

echo " give argument"

BEGIN  awk' {FS=" "}
{a[$7]+=$5}END{for (i in a){print i, " total cost per model "a[i]}}' 

exit 1
fi

awk '/^TK/{print $2,$3;c+=$5}{a[$7]+=$5}END{x="Total cost ";print x" for TK is "c ORS;for (i in a){print i"\t" x" per model "a[i]}}' file

awk '/^TK/{print $2,$3;c+=$5}{a[$7]+=$5}END{print "Total cost for TK is "c;for (i in a){print i, " total cost per model "a[i]}}' cars.txt

 awk '{split($(NF-1),a,"/");b[a[3]]+=$(NF-2)}END{for(i in b) print i,"$"b[i]}' file
2006 $14000
2007 $23400
2008 $98000
2009 $42000