|
Sorry thanks for your replies but i didn't put the entire file so here it is:
200808260640 0 11383
200808210640 0
200808300640 0
200808300640 0
200808300640 0
200808260640 336528522 8844
200808260640 724271039 8080
200808260640 583502861 8077
200808210640 0
200808210640 0
200808210640 0
200808290640 0
200808290640 0
200808290640 0
200808290640 0
200808150640 0 7667
200808160640 0 3285
200808310640 0
200808150640 634799861 4703
200808150640 329658775 4704
200808150640 588901581 4875
200808160640 201718658 1424
What i want to do is sum all the $2 for the same date and save the $3 for that date. E.g like a posted in the first post.
200808150640 0 7667
200808150640 634799861 4703
200808150640 329658775 4704
200808150640 588901581 4875
Expected result:
200808150640 (634799861+329658775+588901581) 7667
i want to do this for the entirely file . Many thanks in advice.
|