I want to add the above date to each line on a prstat log file

Question

I have a prstat log, as you all know the date and time is recorded on the top of the log file, I would like to add that date and time to the begging of each line until it gets to a new date, then I would do the same for that part of the log.

Is this possible?, is there a way to do this through commands or a script, I would've created a script to do so, but it's too late as the data has already been collected.

Answer 1

Assuming date format is yyyy-mm-dd hh:mi:ss you can use this perl script:

#!/usr/bin/perl -w

open(FILEH,"<","your.log") or die "cannot open file";
my $date = "0000-00-00 00:00:00";

while(<FILEH>) {
    if( /^([A-Z][a-z]{2}\s[A-Z][a-z]{2}\s[0-9]+\s[0-2][0-9]:[0-5][0-9]:[0-5][0-9]\s[0-9]{4})$/ ) {
        $date = $1;
    }
    else {
        print "$date $_";
    }
}

Change your.log with full path of your log file.

Answer 2

i don't know python much more, but i tried

#!/usr/bin/env python

Each_line = [line.split() for line in open('/tmp/prstat.log')]

for n in xrange(len(Each_line)):
    if '2008' in Each_line[n]:
         print " ".join(Each_line[n])," ".join(Each_line[n+1])