#!/usr/bin/perl use strict; my $infile = 'worker.log'; open IN,'<',$infile or die "$!"; # input my %data = (); while () { chomp; next unless /Task:id=(\d+)/; my $taskid = $1; my (undef,$timestamp,undef) = split /\s+/,$_,3; if (/(Started|Submitted|Done).*(consuming|job)/){ my $i = ($1 eq 'Done') ? 1 : 0; my $proc = ($2 eq 'consuming') ? $2 : 'Submitted'; $data{$taskid.' '.$proc}[$i] = $timestamp; } } close IN; # output print join ',',('Task id','Start time',"End time\n"); for my $id (reverse sort keys %data){ printf "%s,%s,%s\n",$id,@{$data{$id}}; }