I have a Perl script that I run and the out come as showing below: Reading: server 1\08121100.mls Log chain 2: Reading: server 2\08120700.mls Reading: server 2\08120900.mls Reading: server 2\08121100.mls Log chain 3: Reading: server 3\08120700.mls Reading: server 3\08120900.mls Reading: server 3\08121100.mls ================================ # Successful Syncs: 2535 # Failed Syncs: 34 ================================ Total: 2569
Average Sync Time: 22.05 sec However, it’s only on print screen and I would like to do the following: 1. Save it as an excel file 2. Access another file let’s call it Mark in the path (C:\Mark.xls) with error codes to show me the Failed Syncs errors. Let’s say in the Mark.xls spreadsheet has the following error codes:” below error are not accurate as what I have in the spreadsheet. It’s just an example of type of erros” ================================ Event ID: Msg 0 Authentication 1 Application Error 2 LoadStatus ================================ I would like the out come in the new saved spreadsheet as following: ================================ # Successful Syncs: 2535 ================================ # Event ID 0: 30 #Event ID 2: 4 --------------------------------------------------------------- Total # Failed Syncs: 34 ================================ Total: 2569 Average Sync Time: 22.05 sec I’m very new on this Perl scripting please help on it Thanks, Mark -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
