data formatting in excel using perl

[pingme8705]

hi This is partial output of the excel file

Command | output
show run | in encryption | service password-encryption
-------------------------- | fsddfsfsdfsdfsd sdfs sd
show ntp status | clock synchronised. 34.45.54.54

here i want to check for the a word say "encryption" in the first
column and check for the same or other pattern in second column until
next command appears in first column. can anyone comment on this ?

[jmcnamara]

Since you posted this initially on Perlmonks I'll try to answer it
there:

http://www.perlmonks.org/index.pl?node_id=496365

John.
--