Hi,
Your awk script doesnt give me exactly what I want. Have a look below:
$ cat cm_activities_170408:0302.log
############################ ANALYST REPORT ####################################
LOGIN_ID ACTION_CODE DATE
---------------- ------------------------------ ---------
CASE_REFERENCE FRAUD_TYPE_ID ESTIMATE_LOSS
---------------------------------------------------------------- ------------------------------ -------------
james_j Assign 17-MAR-08
0838521885 High Aggregate Cost of Calls 112457.79
james_j Assign 17-MAR-08
0838117486 High Aggregate Cost of Calls 150801.75
james_j Assign 17-MAR-08
0833003470 High Frequency 77513.92
hyman_c Open 19-MAR-08
0838521885 High Aggregate Cost of Calls 112457.79
hyman_c Open 19-MAR-08
0838521885 High Aggregate Cost of Calls 112457.79
hyman_c Assign 19-MAR-08
0832090883 PD Summary alarm 29401.46
hyman_c Open 01-APR-08
0838521885 High Aggregate Cost of Calls 112457.79
hyman_c Open 07-APR-08
0838521885 High Aggregate Cost of Calls 112457.79
hyman_c Assign 07-APR-08
0734646922 Very Long Duration Call 4
hyman_c Assign 07-APR-08
0833063410 Very Long Duration Call 4261.97
hyman_c Assign 07-APR-08
0782078038 Very Long Duration Call .19
hyman_c Assign 07-APR-08
0730799413 Very Long Duration Call 50.13
hyman_c Open 07-APR-08
0832090883 PD Summary alarm 29401.46
hyman_c Open 07-APR-08
0832090883 PD Summary alarm 29401.46
hyman_c Open 08-APR-08
0734646922 Very Long Duration Call 4
hyman_c Open 08-APR-08
0782078038 Very Long Duration Call .19
hyman_c Open 08-APR-08
0734646922 Very Long Duration Call 4
hyman_c Open 08-APR-08
0782078038 Very Long Duration Call .19
hyman_c Open 08-APR-08
0838521885 High Aggregate Cost of Calls 112457.79
hyman_c Open 08-APR-08
0832090883 PD Summary alarm 29401.46
hyman_c Open 08-APR-08
0782078038 Very Long Duration Call .19
hyman_c Open 09-APR-08
0833063410 Very Long Duration Call 4261.97
hyman_c Open 09-APR-08
0832090883 PD Summary alarm 29401.46
hyman_c Open 09-APR-08
0832090883 PD Summary alarm 29401.46
hyman_c Open 09-APR-08
0734646922 Very Long Duration Call 4
hyman_c Open 09-APR-08
0730799413 Very Long Duration Call 50.13
hyman_c Open 09-APR-08
0838521885 High Aggregate Cost of Calls 112457.79
hyman_c Open 10-APR-08
0833063410 Very Long Duration Call 4261.97
hyman_c Open 10-APR-08
0782078038 Very Long Duration Call .19
hyman_c Open 10-APR-08
0782078038 Very Long Duration Call .19
hyman_c Open 10-APR-08
0734646922 Very Long Duration Call 4
hyman_c Open 10-APR-08
0734646922 Very Long Duration Call 4
hyman_c Open 10-APR-08
0833063410 Very Long Duration Call 4261.97
hyman_c Open 10-APR-08
0730799413 Very Long Duration Call 50.13
hyman_c Open 10-APR-08
0730799413 Very Long Duration Call 50.13
hyman_c Open 11-APR-08
0832090883 PD Summary alarm 29401.46
hyman_c Open 11-APR-08
0734646922 Very Long Duration Call 4
nhlaph_pr Assign 15-APR-08
0832124374 PD Summary alarm 72957.64
$
$ cat test_123.ksh
#!/bin/ksh
set -x
#########################################################################
#
awk 'END { for (k in x)
printf "ACTION_CODE: %s\n\n%s\n\nTotal: %60.2f\n\n",
k, x[k], sum[k] }
NR > 1 { s = $2; $2 = ""
x [s]= x [s]? x[s]RS$0 : $0; sum [s]+= $NF }' /minotaur/Log/stats/cm_activities_170408:0302.log > xxx.log
$ cat xxx.log
ACTION_CODE:
Total: 0.00
ACTION_CODE: ------------------------------
---------------- ---------
---------------------------------------------------------------- -------------
Total: 0.00
ACTION_CODE: Assign
james_j 17-MAR-08
james_j 17-MAR-08
james_j 17-MAR-08
hyman_c 19-MAR-08
hyman_c 07-APR-08
hyman_c 07-APR-08
hyman_c 07-APR-08
hyman_c 07-APR-08
nhlaph_pr 15-APR-08
Total: 113.00
ACTION_CODE: FRAUD_TYPE_ID
CASE_REFERENCE ESTIMATE_LOSS
Total: 0.00
ACTION_CODE: High
0838521885 Aggregate Cost of Calls 112457.79
0838117486 Aggregate Cost of Calls 150801.75
0833003470 Frequency 77513.92
0838521885 Aggregate Cost of Calls 112457.79
0838521885 Aggregate Cost of Calls 112457.79
0838521885 Aggregate Cost of Calls 112457.79
0838521885 Aggregate Cost of Calls 112457.79
0838521885 Aggregate Cost of Calls 112457.79
0838521885 Aggregate Cost of Calls 112457.79
Total: 1015520.20
ACTION_CODE: Open
hyman_c 19-MAR-08
hyman_c 19-MAR-08
hyman_c 01-APR-08
hyman_c 07-APR-08
hyman_c 07-APR-08
hyman_c 07-APR-08
hyman_c 08-APR-08
hyman_c 08-APR-08
hyman_c 08-APR-08
hyman_c 08-APR-08
hyman_c 08-APR-08
hyman_c 08-APR-08
hyman_c 08-APR-08
hyman_c 09-APR-08
hyman_c 09-APR-08
hyman_c 09-APR-08
hyman_c 09-APR-08
hyman_c 09-APR-08
hyman_c 09-APR-08
hyman_c 10-APR-08
hyman_c 10-APR-08
hyman_c 10-APR-08
hyman_c 10-APR-08
hyman_c 10-APR-08
hyman_c 10-APR-08
hyman_c 10-APR-08
hyman_c 10-APR-08
hyman_c 11-APR-08
hyman_c 11-APR-08
Total: 272.00
ACTION_CODE: ACTION_CODE
LOGIN_ID DATE
Total: 0.00
ACTION_CODE: Very
0734646922 Long Duration Call 4
0833063410 Long Duration Call 4261.97
0782078038 Long Duration Call .19
0730799413 Long Duration Call 50.13
0734646922 Long Duration Call 4
0782078038 Long Duration Call .19
0734646922 Long Duration Call 4
0782078038 Long Duration Call .19
0782078038 Long Duration Call .19
0833063410 Long Duration Call 4261.97
0734646922 Long Duration Call 4
0730799413 Long Duration Call 50.13
0833063410 Long Duration Call 4261.97
0782078038 Long Duration Call .19
0782078038 Long Duration Call .19
0734646922 Long Duration Call 4
0734646922 Long Duration Call 4
0833063410 Long Duration Call 4261.97
0730799413 Long Duration Call 50.13
0730799413 Long Duration Call 50.13
0734646922 Long Duration Call 4
Total: 17277.54
ACTION_CODE: PD
0832090883 Summary alarm 29401.46
0832090883 Summary alarm 29401.46
0832090883 Summary alarm 29401.46
0832090883 Summary alarm 29401.46
0832090883 Summary alarm 29401.46
0832090883 Summary alarm 29401.46
0832090883 Summary alarm 29401.46
0832124374 Summary alarm 72957.64
Total: 278767.86
$