Re: Aggregating repeating lines

2006-12-06 Thread Rob Dixon
Michael Alipio wrote: Hi, I have a long log file that looks like this: 7491| 210.23.185.123 | PH202597706 7491| 210.23.169.91| PH202594221 7303| 201.252.130.245 | AR201955854 9318| 210.205.6.225| KR201892149 9930| 210.19.229.57| MY201418551

Re: Aggregating repeating lines

2006-12-05 Thread Jeff Pang
> >And I'm thinking, perhaps I should get a unique list of all countries included >in this logfile and only then I can aggregate their Bytes by using regexp. > >Can you give me some hints on how I can accomplish this goal.. > No regex is needed.You can use a hash to store the 'country' column a

Re: Aggregating repeating lines

2006-12-05 Thread John W. Krahn
Michael Alipio wrote: > Hi, Hello, > I have a long log file that looks like this: > > 7491| 210.23.185.123 | PH202597706 > 7491| 210.23.169.91| PH202594221 > 7303| 201.252.130.245 | AR201955854 > 9318| 210.205.6.225| KR201892149 > 9930| 210.19.229.5