text to csv conversion

Shell Programming and Scripting
1

Thank u every body ......just need a help so that a text file needs to be converted into CSV.............

my log file is as follows

Host scsi3: usb-storage
Vendor: Maxtor
Product: OneTouch III
Serial Number: 044303E5
Protocol: Transparent SCSI
Transport: Bulk
Quirks:
Tue May 31 09:01:21 GMT 2011

Host scsi3: usb-storage
Vendor: Maxtor
Product: OneTouch III
Serial Number: 044303E5
Protocol: Transparent SCSI
Transport: Bulk
Quirks:
Tue May 31 11:22:14 GMT 2011

Host scsi4: usb-storage
Vendor: Maxtor
Product: OneTouch III
Serial Number: 044303E5
Protocol: Transparent SCSI
Transport: Bulk
Quirks:
Tue May 31 11:29:44 GMT 2011

Now how can i convert this to csv file so that i can export it into some database

for example:-

scsi3, vendor, product_name, serial_no, protocol_used, transport, quirks
usb-storage, Maxtor, OneTouchIII, 044303E5, Transparent SCSI, Bulk, Tue May 31 09:01:21 GMT 2011
usb-storage, Maxtor, OneTouchIII, 044303E5, Transparent SCSI, Bulk, Tue May 31 11:22:14 GMT 2011
usb-storage, Maxtor, OneTouchIII, 044303E5, Transparent SCSI, Bulk, Tue May 31 11:29:44 GMT 2011

after some googling i got a clue about getline command with awk....... but dont know how to use;............

any suggestions in this regards greatly appreciated
regards

the orignal file is uploaded for reference...

2

This doesn;t print the header, you can hard code it ,

 awk -F: '{if($0 && ($0!~/GMT 2011/)){printf "%s,",$2}else if($0~/GMT 2011/){printf "%s",$0}else{ printf "\n" }}' test.txt

Output

 usb-storage, Maxtor, OneTouch III, 044303E5, Transparent SCSI, Bulk,,Tue May 31 09:01:21 GMT 2011
 usb-storage, Maxtor, OneTouch III, 044303E5, Transparent SCSI, Bulk,,Tue May 31 11:22:14 GMT 2011
 usb-storage, Maxtor, OneTouch III, 044303E5, Transparent SCSI, Bulk,,Tue May 31 11:29:44 GMT 2011
3 
awk -F":" '!/^Quirks/ && NF>1{printf /GMT/?$0"\n":$2","}' filename
4

Manually write the headers.

 
perl -00 -F: -lane 'BEGIN{$,=","};$_=~s/\n//g for @F;print @F[1,3,5,7,9]'
5

I will go with Getmmg:.. headers need to be added ....

sed '/GMT/!s/^[A-Z].*://g' filename|sed -e :a -e '/GMT/!N;s/\n/,/;ta' -e 's/^,//'