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]

Reply via email to