The following input needs to be manipulated as follows:
INPUT from file or results of command:
============start:
Medium identifier : a45c0213:47eb5485:0aec:0321
Medium label : SQL Disk_11516
Location : [Windows_System_Library: /backup_09/a45c0213547eb4d2750aec50315.fd]
Protected : None
Medium identifier : a45c0213:47f09a86:0bbb:00d5
Medium label : SQL Disk_11582
Location : [Windows_System_Library: /backup_02/a45c0213547f08c5250bbb500ce.fd]
Protected : None
Medium identifier : a45c0213:47ecac55:0aec:040a
Medium label : SQL Disk_11536
Location : [Windows_System_Library: /backup_02/a45c0213547ecac5550aec50408.fd]
Protected : None
Medium identifier : a45c0213:47f5e816:0b15:01bc
Medium label : SQL Disk_11609
Location : [Windows_System_Library: /backup_09/a45c0213547f5e81650b15501ba.fd]
Protected : 05/04/08 04:55:56
Medium identifier : a45c0213:47fb2681:1e72:0052
Medium label : SQL Disk_11649
Location : [Windows_System_Library: /backup_10/a45c0213547fb268151e725004f.fd]
Protected : 05/08/08 04:50:02
finish====================
Notes: the results are formatted so that the first ":" lines up.
The ========start and finsih======= are not part of the results
Need to process the input so that the results yield:
a45c0213:47fb2681:1e72:0052,SQL Disk_11649,/backup_10/a45c0213547fb268151e725004f.fd,None[orthe date shown next to Protected]
(all on 1 line)
Each record Starts with the Medium identifier line and ends with the Protected line.
Thank you.