hi...... thanks for allowing me to start a discussion
i am collecting usb usage details of all users and convert it into csv files so that i can export it into some database..
the input text file is as follows:-
USB History Dump
by nabiy (c)2008
(1) --- Kingston DataTraveler 130 USB Device
instanceID: 0018F3D974B4A9C0E1760896&0
ParentIdPrefix: 7&b62e00e&2
Last Mounted As: \DosDevices\I:
Driver:{4D36E967-E325-11CE-BFC1-08002BE10318}\0033
Disk Stamp: 09/07/2010 15:07
Volume Stamp: 09/07/2010 15:07
(2) --- Kingston DataTraveler 2.0 USB Device
instanceID: 001D0F1E35B25B8C1201011B&0
ParentIdPrefix: 7&1f5848f3&0
Driver:{4D36E967-E325-11CE-BFC1-08002BE10318}\0035
Disk Stamp: 09/06/2010 15:18
Volume Stamp: 09/06/2010 15:18
(3) --- Maxtor OneTouch III USB Device
instanceID: 044303E5&0
ParentIdPrefix:
Driver:{4D36E967-E325-11CE-BFC1-08002BE10318}\0032
Disk Stamp: 09/10/2010 10:09
Volume Stamp: 03/12/2010 10:42
how can i parse this file so that i can get in following format
hostname Devic_name instanceID ParentPrefix LastMountedAsDriver Disk_Stamp
pcname kingston 001xxxx 7&869 xxxxxx 09/07/2
pcname maxtor 040xxx xxxxx xxxxxx xxxxxx
pcname kingston 033333 55555 xxxxx xxxxxx
inserted device name column to insert kingston entries
and the second paragraph act as second raw.....
the output desirable is in csv format for database with some batch or awk script........
any suggestion in this regard is greatly appreciated
thanks in advance/.........