Vista - extract the necessary rowdata from log/txt file from query eventqu

I got the output log/txt/csv file from eventquery.vbs. and now I just want to
extract the necesary rowdata from the output file which eventquery syntex
can;t do. The output file from eventquery is very complicated and i want to
make the view more simple. Would you please tell me how. thanks.

"tonycd" <tonycd@xxxxxx> wrote in message
news:6A21F0DD-45F7-4E5B-A7EF-CE52D5943A47@xxxxxxLet's have a look at
a) your eventquery command, and
b) a typical output line you wish to massage, and
c) the output format you wish to achieve.

"tonycd" <tonycd@xxxxxx> wrote in message
news:18DFC342-24FE-42C6-B1CF-0A41B6E748C4@xxxxxxBelow is some sample code that you could use to massage your output. It is
based on you using the "/fo CSV" switch when running eventquery.vbs. You may
want to massage the "Description" column further in order to enhance
readability.

You could, of course, modify eventquery.vbs itself. This implies that you
familiarise yourself with the way the program is designed.

Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oLog = oFSO.OpenTextFile("d:\Event.txt")
Const Type_ = 0, Event_ = 1, DateTime = 2, Source = 3, Computer = 4
Const Category = 5, User = 6, Description = 7
Const sDelimiter = ""","""

While Not oLog.AtEndOfStream
sLine = Replace(oLog.ReadLine, sDelimiter, "|")
if len(sLine) > 0 then sLine = Left(sLine, Len(sLine) - 1)
aLine = Split(sLine, "|")
If UBound(aLine) < 7 Then
WScript.Echo sLine
Else
WScript.Echo
WScript.Echo "Date: ", aLine(DateTime)
WScript.Echo "Category: ", aLine(Category)
WScript.Echo "User: ", aLine(User)
WScript.Echo "Description", aLine(Description)
End If
Wend
oLog.Close