#!/usr/bin/perl use strict; my $infile = 'worker.log'; my $outfile = 'Consumer.CSV'; my @id = (); print "Please enter the parentid of running process: \n" ; my $reqid = ; chop $reqid; 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; } while ( /\{(\d+)-SUCCESSFUL\}/g ){ push @id,$1 if ($taskid eq $reqid); } } close IN; # output open OUT,'>',$outfile or die "$!"; my @cols = qw(Taskid Started Done); printf OUT "%s,%s,%s\n",@cols; #print join ',',('Task id','Start time',"End time\n"); for my $id (reverse sort keys %data){ printf OUT "%s,%s,%s\n",$id,@{$data{$id}}; }