Using Expect to parse file. 1

[NetworkGhost]

I have a SSH script that runs pings on a router every 15 minutes and send the output to a file. What I want to do is parse the file so it can later be opened in excel.

The output line looks like so:

Success rate is 100 percent (5/5), round-trip min/avg/max = 92/95/108 ms

What I want to do is make it look like:

(5/5) 92 95 108

Can expect do this? Would SED or something else do better? Does anyone have any good examples of how I can start this?


Free Firewall/Network/Systems Support-

http://firewalls.ath.cx

 

[Bong]

This seems like a good application for regexp

%set s "Success rate is 100 percent (5/5), round-trip min/avg/max = 92/95/108 m
s"
regexp {.*(\(\d*/\d*\)).* = (\d*)/(\d*)/(\d*).*} $s a b c d e

now:
% set b
(5/5)
% set c
92
% set d
95
% set e
108

_________________
Bob Rashkin

 

[NetworkGhost]

I dont have regexp available on my server. Cant install anything new. I have expect, perl, ksh, bash, sed and awk. My have more but dont know.

Free Firewall/Network/Systems Support-

http://firewalls.ath.cx

 

[Bong]

I don't know much about Expect, other than that it's an extention of Tcl. I thought that meant it could understand Tcl statements. Not so? (regexp is a regular Tcl statement).

_________________
Bob Rashkin

 

[NetworkGhost]

Worked out great. Thanks for the time. Regexp looks like a pretty useful tool.

Free Firewall/Network/Systems Support-

http://firewalls.ath.cx