From owner-freebsd-isp Thu Oct 12 4: 3:34 2000 Delivered-To: freebsd-isp@freebsd.org Received: from siafu.iconnect.co.ke (upagraha.iconnect.co.ke [209.198.248.2]) by hub.freebsd.org (Postfix) with ESMTP id 6238437B503 for ; Thu, 12 Oct 2000 04:03:29 -0700 (PDT) Received: from [212.22.163.2] (helo=poeza.iconnect.co.ke) by siafu.iconnect.co.ke with esmtp (Exim 2.12 #1) id 13jg7P-000D26-00; Thu, 12 Oct 2000 14:01:47 +0300 Received: from wash by poeza.iconnect.co.ke with local (Exim 3.16 #1) id 13jgA6-0009xM-00; Thu, 12 Oct 2000 14:04:34 +0300 Date: Thu, 12 Oct 2000 14:04:34 +0300 From: Odhiambo Washington To: FBSD-ISP Subject: Processing details files Message-ID: <20001012140434.A38247@poeza.iconnect.co.ke> Mail-Followup-To: Odhiambo Washington , FBSD-ISP Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Operating-System: FreeBSD poeza.iconnect.co.ke 3.5-STABLE FreeBSD 3.5-STABLE X-URL: web.iconnect.co.ke/users/wash X-Accept-Language: en fr X-Editor: Pico http://www.washington.edu/ X-Location: Mombasa, Kenya, East Africa X-Uptime: 1:40PM up 3 days, 16:28, 1 user, load averages: 0.22, 0.20, 0.09 Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Hi Kindly advise how I can process such a file: NB: Did I mention to you that I have no idea how to write a script? ;-) Log starts on Tue Aug 1 00:01:15 2000. Date Logout Userid IP Time Term M# Sent(b) Recieved(b) 08/06/20 11:09:23 caacall@mombasa 20 78.45 Idle 27 416836 437705 08/06/20 23:19:01 caacall@mombasa 20 701.3 Lost 27 6369328 5897091 08/07/20 13:40:18 caacall@mombasa 20 316.0 Lost 27 1455872 1472357 08/07/20 16:52:30 caacall@mombasa 20 185.5 Lost 27 740305 462882 08/07/20 22:10:52 caacall@mombasa 20 307.9 Lost 27 2350597 2499529 08/07/20 23:31:28 caacall@mombasa 20 78.65 User 27 144726 300747 08/08/20 09:42:25 caacall@mombasa 20 44.68 Idle 27 502168 520524 I know I may be asking for so much but pls just help me out. I need a small script that will take a file with this date and give me the TOTALS for column5, column8 and column9 If possible, if I can get col5 interpreted into hrs:min:sec Any little help highly appreciated. -Wash -- Odhiambo Washington Inter-Connect Ltd., wash@iconnect.co.ke 5th Flr Furaha Plaza Tel: 254 11 222604 Nkrumah Rd., Fax: 254 11 222636 PO Box 83613 MOMBASA, KENYA. A leading authority is someone lucky who guessed right. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message