you might want to try:
#!/usr/bin/perl -w
use strict;
my $i = 1;
my $min = -1;
while(<>){
my($n1,$d1,$b1) =
/^INCREMENTAL\s+OF\s+(.+?)\s+.*?ON\s+(.+?)\s+.+\s+(\d+)$/i;
$i++ if($b1 < $min);
$min = $b1;
print "\"$d1\",\"TAPE $i\",\"$n1\",\"$b1\"\n";
}
david
Laddo wrote:
> Hi all
>
> I have a log file which is generated by backup script and i am writing a
> perl script to sort the log so as to prepare it to put into mysql
> database and iam having a problem in doing that.
>
> my log file is like this (I have written line numbers for clarity only )
>
> 1 INCREMENTAL OF staff ON 2002-08-28 FROM 08/27/02 STARTS AT At
> block 315825.
> 2 INCREMENTAL OF www.cs <http://www.cs> ON 2002-08-28 FROM
> 08/27/02 STARTS AT At block 102860.
> 3 INCREMENTAL OF staff_homepages ON 2002-08-28 FROM 08/27/02
> STARTS AT At block 103142.
> 4 INCREMENTAL OF ftp.cs <ftp://ftp.cs> ON 2002-08-28 FROM
> 08/27/02 STARTS AT At block 103204
> 5 INCREMENTAL OF local ON 2002-08-28 FROM 08/27/02 STARTS AT At
> block 103216.
> 6 INCREMENTAL OF Hyper-G ON 2002-08-28 FROM 08/27/02 STARTS AT At
> block 103236.
> 7 INCREMENTAL OF submissions ON 2002-08-28 FROM 08/27/02 STARTS
> AT At block 104278.
> 8 INCREMENTAL OF src ON 2002-08-28 FROM 08/27/02 STARTS AT At
> block 110373.
> 9 INCREMENTAL OF IMAP ON 2002-08-28 FROM 08/27/02 STARTS AT At
> block 110455.
>
> i want a script that can give me output like this
>
> "2002-08-28","$PROBLEM","staff", "315825"
>
> $PROBLEM is actually tape number which should be derived from
> blocknumbers in the logfile e.g say the initial TAPE No =1 and the
> script should check if the block number is greater than the block number
> in the next line it should replace $PROBLEM with TAPE 1 Other wise
> should do something like $PROBLEM=$TAPE +1
>
> Like in my example
> line 1 should give the output as
>
> "2002-08-28","TAPE 1","staff", "315825" # because 315825 > 102860
>
> line 2 should be
>
> "2002-08-28", "TAPE 2","www.cs", "102860" # tape=$tape +1 is required
> because 102860 ! > 103142
>
>
> and the same with other lines ....
>
> i can do it with awk and bash but as iam learning perl iam trying to
> write everything in perl. For all the guru's out there i know its very
> simple please help
>
>
> Hmmm i hope i have explained the concept correctly
>
> Cheers
>
> Bobby
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
