I have a flat file sort by Phonenumber and Bigin call fileA.txt
Phonnumber|Begin|Endca|D1|D2|Diff
4159061234|10:00|10:01|a1|a2|60
4159061234|10:00|10:06|b1|b2|360
4159061234|10:05|10:06|c1|c2|60
4159061234|10:12|10:15|d1|d2|180
3045678934|10:25|10:28|x1|x2|180
3045678934|10:25|10:30|y1|y2|300
3045678934|10:28|10:31|z1|z2|180
....................

How do I write a code in ksh so it will check the
phone number and if phone number with same begin call then count
and give outout.txt as a result

Phonnumber|Begin|Endca|D1|D2|Call Times
3045678934|10:25|10:28|x1|x2|2
3045678934|10:28|10:31|z1|z2|1
4159061234|10:00|10:01|a1|a2|2
4159061234|10:05|10:06|c1|c2|1
4159061234|10:12|10:15|d1|d2|1

......................................

Thanks

===


Here is my code
but my asnswer is
3045678934,10:25,10:28,x1,x2,1
3045678934,10:28,10:31,z1,z2,1
4159061234,10:00,10:01,a1,a2,1
4159061234,10:05,10:06,c1,c2,1
4159061234,10:12,10:15,d1,d2,1

I tried but my count is incorrect, how do you count it ? please help. Thanks

Suggest you first read the rules about bumping your post - this will not get you a quicker response.

Quick and dirty solution if the file isn't too big:

IFS='|'
while read a b
do
  print $a"|$b"'|'$(grep -c ^$a z.dat)
done < z.dat

The code you have gave me this answer

4159061234|10:00|10:01|a1|a2|60|4
4159061234|10:00|10:06|b1|b2|360|4
4159061234|10:05|10:06|c1|c2|60|4
4159061234|10:12|10:15|d1|d2|180|4
3045678934|10:25|10:28|x1|x2|180|3
3045678934|10:25|10:30|y1|y2|300|3
3045678934|10:28|10:31|z1|z2|180|3



It is not what I expected to get.
Thanks,

nawk -f brit.awk fileA.txt

brit.awk:

BEGIN {
  FS=OFS="|"
}

{
  idx= $1 SUBSEP $2
  NF--; $1 = $1
  if (!(idx in arr))
     arr[ idx ] = $0
  cnt [idx]++
}
END {
  for ( i in arr )
    print arr[i], cnt[i]
}