Exactly, hence: [quote] the only thing missing is to find a way to just take the earliest time of each day. in other words the above output should be: 0 DaysLate [/quote] ---------------------------------------- > Date: Tue, 21 Dec 2010 13:54:41 -0600 > From: lesmikesell at gmail.com > To: centos at centos.org > Subject: Re: [CentOS] Text Proccessing script - advice? > > On 12/21/2010 1:40 PM, Roland RoLaNd wrote: > > > > > > > > awk -F , '{if ($4> "09:10:00") print $2 " was late on", $3 " by coming at ",$4}' test | tee DaysLate ; wc -l DaysLate > > > > 01368 was late on 2010-12-02 by coming at 10:54:00 > > > > 01368 was late on 2010-12-02 by coming at 13:07:04 > > > > 01368 was late on 2010-12-02 by coming at 18:54:01 > > > > 01368 was late on 2010-12-03 by coming at 13:53:00 > > > > 01368 was late on 2010-12-03 by coming at 16:07:00 > > > > 5 DaysLate > > On my calendar 12-02 and 12-03 are only 2 days... > > -- > Les Mikesell > lesmikesell at gmail.com > > > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos