Computer Hope

Software => Computer programming => Topic started by: certteam on September 15, 2010, 12:23:51 AM

Title: covert a text file into csv using awk
Post by: certteam on September 15, 2010, 12:23:51 AM

    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/.........