Script to Extract time from log files and write to a excel

06-06-2008

Registered User

17, 0

Join Date: Jun 2008

Last Activity: 9 October 2008, 3:22 PM EDT

Posts: 17

Thanks Given: 0

Thanked 0 Times in 0 Posts

Script to Extract time from log files and write to a excel

Can someone help me with writing a unix script for following requirement

1) I have a log file in which we have start time and end time (format: hh:mm:ss)
Example: starting script on Thu Jun 5 20:50:52
Thu Jun 5 21:55:33 - Script Completed
2) I want to extract start time and end time of the script (ex: 20:50:52 and 21:55:33) from the log file and write into a excel file.
3) I need to collect these start and end times every day and write into the excel (this excel will be stored in a shared drive) and also I have around 50 logs which i need to go thru to get the start and end times.
4) Once the start and end times are extracted into excel file, I need to get the time taken for completion of the script (by substracting end time from start time) and populate the result value into another cell of the excel.
For example, My ouput should look like this.
Start Time End Time Time to Complete
19:41:42 20:25:18 00:43:36

Your help with this script is greatly appriciated.

Thanks,
S

santosham

View Public Profile for santosham

Find all posts by santosham

GEMS-SERVER(1) gems documentation GEMS-SERVER(1) NAME
gems-server - Transmit a shell session in real time. SYNOPSIS
gems-server [-ip ip] [-port p] [-maxconn n] [-wait m] [-log dest] [-noscript] [-script_bin script] gems-server -h | -v DESCRIPTION
Transmits a shell session to be shown in real time in various different computers or terminals. gems-server transmits data in real time to clients via a network connection. Each one of these clients must run the gems-client(1) program to establish connection and receive the transmitted data. Clients can connect and disconnect at any given time, but of course they will only receive the data that is transmitted while they are connected (just like a radio transmission/reception system). The gems system is normally used to transmit a console session and show it in various computers at the same time, but it is also possible to transmit any other kind of data. OPTIONS
-ip IP address where connections will be accepted. -port TCP port. Default: 6666. -maxconn Do not accept more than n simultaneous clients. Default: 25. -wait Wait until m clients are connected before starting the transmission. This is useful to ensure that the first m clients will receive all data transmitted. The default behavior is to start transmission immediately, without waiting for client connections. -log By default, the server does not write log messages. This option configures the destination of logs. The dest argument can be `sys- log' (to log through syslogd(8)), `stderr' (to log through standard error output), or it can be an arbitrary filename (log messages will be appended to the file, if it exists). -noscript By default, the server executes the script(1) program to take terminal data and transmit it. When this option is used the server will not run script, and data will be read form standard input. -script_bin Specifies the location of the script(1). program. Default: /usr/bin/script. -h Show a short help message. -v Show version information. FILES
/var/lock/gems-server.PORT Lock file. gems-server creates this file on initialization and deletes it on exit. PORT is replaced by the TCP port used. gems- server will not run if this file is already present in the system. AUTHORS
Diego Essaya <dessaya@fi.uba.ar> Emiliano Castagnari <ecastag@fi.uba.ar> SEE ALSO
gems-client(1), script(1), syslogd(8) gems AUGUST 2004 GEMS-SERVER(1)

Shell Programming and Scripting