Shell Programming and Scripting

Dear Team,
I am try n gerrating a report by writing a shell script, the content of the report should be aggrigated based on date value exist in the content of the file. initially the file is zip format
My file content is in below format

Code:

031627787  034626800357002013050613310400000013500 CLT01 V1BTAG31627787 0000 AMK0
031627787    0313557408002013050613341700000007000 CLT01 GRAZM231627787 0000 AMK0
031627787    0316579457002013050713335900000067200 CLT01 GEIDOR31627787 0000 AMK0
031627787  046329433121002013050713443800000024200 CLT01 KLAGSU31627787 0000 AMK0
i am calculating number of calls based on date as where $PrevDay is the Previous date value
calls=`gunzip -c -v $HOME/$path1/$profile/cdr/*$FileDate*.cdr.gz|awk -v date=$PrevDay\
'{ if (substr($0,43,8)== date) summe=summe+1}END {print summe}'`

File contains the date in the data of 2nd column, report should aggrigate data based on call date in 2nd column, e.g calls for 20130506 should come in one row and calls for 201307 should come in 2nd row. This call_date and values in the file should have a specific index location in the file. As our call date starts from 43 and is length 8

Only requirement is to find out such call_date from the file calculate number of call as above script is calculating.
The report output in report would be like
data1 data2 data3 call_date1 data4
data1 data2 data3 call_date2 data4

Kindly suggest.

The necessary algorithm is called a "control break", you might want to read this tutorial on how to do it.

I hope this helps.

bakunin