parse data from text file

[rharrington10]

Need to parse parts of a raw text file and convert it to an Excel file. Seems simple, and have tried multiple approaches, but none have been successful. Any assistance would be greatly appreciated.

I would provide actual files, but do not have permissions to post attachments.

sample data:

!
--More-- voice-port 2/0/0
no snmp trap link-status
cptone AP
timeouts interdigit 4
description Analog phone
station-id name winter Analog
station-id number 58572000
caller-id enable
!
voice-port 2/0/1
no snmp trap link-status
cptone AP
timeouts interdigit 4
description Analog phone
station-id name winter Analog
station-id number 58572001
caller-id enable
!
voice-port 2/0/2
no snmp trap link-status
cptone AP
timeouts interdigit 4
description Analog phone
--More-- station-id name winter Analog
station-id number 58572002
caller-id enable
!
voice-port 2/0/3
no snmp trap link-status
cptone AP
timeouts interdigit 4
description Analog phone
station-id name winter Analog
station-id number 58572003
caller-id enable
!
voice-port 2/0/4
no snmp trap link-status
cptone AP
timeouts interdigit 4
description Analog phone
station-id name winter Analog
station-id number 58572004
caller-id enable
!
voice-port 2/0/5
--More-- no snmp trap link-status
cptone AP
timeouts interdigit 4
description Analog phone
station-id name winter Analog
station-id number 58572005
caller-id enable
!
dial-peer voice 9992000 pots
corlist incoming international
description Analog phone
translation-profile incoming tp_add_cor
--More-- huntstop
preference 4
destination-pattern 58572000
progress_ind alert strip
authentication username 58572000 password 7 58572000
port 2/0/0
!
dial-peer voice 9992001 pots
corlist incoming local
description Analog phone
translation-profile incoming tp_add_cor
huntstop
preference 4
destination-pattern 58572001
progress_ind alert strip
authentication username 58572001 password 7 58572001
port 2/0/1
!
dial-peer voice 9992002 pots
corlist incoming international
description Analog phone
translation-profile incoming tp_add_cor
huntstop
--More-- preference 4
destination-pattern 58572002
progress_ind alert strip
authentication username 58572002 password 7 58572002
port 2/0/2
!
dial-peer voice 9992003 pots
corlist incoming national
description Analog phone
translation-profile incoming tp_add_cor
huntstop
preference 4
destination-pattern 58572003
progress_ind alert strip
authentication username 58572003 password 7 58572003
port 2/0/3
!
dial-peer voice 9992004 pots
corlist incoming international
description Analog phone
translation-profile incoming tp_add_cor
huntstop
preference 4
--More-- destination-pattern 58572004
progress_ind alert strip
authentication username 58572004 password 7 58572004
port 2/0/4
!
dial-peer voice 9992005 pots
corlist incoming international
description Analog phone
translation-profile incoming tp_add_cor
huntstop
preference 4
destination-pattern 58572005
progress_ind alert strip
authentication username 58572005 password 7 58572005
port 2/0/5





desired results:

voice-port	no snmp trap	cptone	timeouts	description	station-id name	station-id number	caller-id	corlist incoming
2/0/0	link-status	AP	interdigit 4	Analog phone	winter Analog	58572000	enable	international
2/0/1	link-status	AP	interdigit 4	Analog phone	winter Analog	58572001	enable	local
2/0/2	link-status	AP	interdigit 4	Analog phone	winter Analog	58572002	enable	international
2/0/3	link-status	AP	interdigit 4	Analog phone	winter Analog	58572003	enable	national
2/0/4	link-status	AP	interdigit 4	Analog phone	winter Analog	58572004	enable	international
2/0/5	link-status	AP	interdigit 4	Analog phone	winter Analog	58572005	enable	international
2/0/6	link-status	AP	interdigit 4	Analog phone	winter Analog	58572006	enable	international
2/0/7	link-status	AP	interdigit 4	Analog phone	winter Analog	58572007	enable	international
2/0/8	link-status	AP	interdigit 4	Analog phone	winter Analog	58572008	enable	international
2/0/9	link-status	AP	interdigit 4	Analog phone	winter Analog	58572009	enable	international
2/0/10	link-status	AP	interdigit 4	Analog phone	winter Analog	58572010	enable	international
2/0/11	link-status	AP	interdigit 4	Analog phone	winter Analog	58572011	enable	international
2/0/12	link-status	AP	interdigit 4	Analog phone	winter Analog	58572012	enable	international
2/0/13	link-status	AP	interdigit 4	Analog phone	winter Analog	58572013	enable	international
2/0/14	link-status	AP	interdigit 4	Analog phone	winter Analog	58572014	enable	international

<tbody>
</tbody>

 

[DanteAmor]

Reviewing your examples, I see that the following data does not match your headlines, what is done in those cases?

dial-peer voice 9992005 pots
corlist incoming international
description Analog phone
translation-profile incoming tp_add_cor
huntstop
preference 4
destination-pattern 58572005
progress_ind alert strip
authentication username 58572005 password 7 58572005
port 2/0/5

desired results:

voice-port	no snmp trap	cptone	timeouts	description	station-id name	station-id number	caller-id	corlist incoming

<tbody>
</tbody>

 

[rharrington10]

sorry, first post. should have put a separator in there to distinguish. there are two elements. the voice port and the dial-peer. you've posted the second portion of the data. the ports match. only trying to capture the corlist incoming portion of the second element.

 

[DanteAmor]

You could upload a txt file and a file of how it should look in excel.

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

 

[rharrington10]

Thanks for your willingness to help, Dante. I believe I've pretty much figured out what I need.

 

[DanteAmor]

You're welcome