Shell Programming and Scripting

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.

Something along these lines.

nawk -f rcky.awk myInputFile

rcky.awk:

Code:

/^Medium identifier/,/^Protected/ {
  printf("%s%c", substr($0, index($0, ":")+2), ($0 ~ /^Protected/) ? "\n" : ",")
}

Thank you. Works just fine!