Reading a Log and Extracting Data

Using C# or VB.NET

Ok here is my situation. I have a text document that I extracted from another program with lots of raw data. I would like to create a program to search this raw text document that pull certain parts from it and place that info into a datagrid or an array or anything at all, just pulling the data is what I need. Here is an example:

(Note the Raw Data is formatted very well)
Text Doc:
["Guild"] = "Guild Name",
["DBversion"] = "1.1",
["DateExtracted"] = "07/14/05 02:27:30",
["Hour"] = 3,
["Locale"] = "enUS",
["Members"] = {
["Member1"] = {
["Note"] = "",
["Class"] = "Fighter",
["Level"] = 31,
},
["MemberX"] = {
["Note"] = "",
["Class"] = "Warrior",
["Level"] = 33,
},

I would like to pull the memeber names with the info in their tag and put it into a string so that I could later format it into HTML code. If you know of any other way to approach this problem please help me out. Thanks. Any questions please post.

Placing into a Datagrid I believe would allow me the most opitions when converting it to HTML to place into a table because of the sorting abilities, so that would be awesome if someone could help with that, but any help would be good. Thank you.

[1263 byte] By [GhostGT] at [2007-12-16]
# 1
If the data is well formatted with fixed seperators the easiest would be to use MS Excel and use the Import Wizard / Or even MS Access has an Import Wizard.

Just use the Wizard to import your data into MS Access/Excell. Any Addtional columns can be deleted after the import.

Once you have the data in a DataBase search and sorts will definately become much faster.
Since searching through flat files is always tougher and slower. You will have to implement your own search algorithm to make it faster - a lot of work. Other way would be to transform the data into XML. once you have it in XML you can load it in a DataSet and display in a DataGrid. As well as use XPath queries to search data.
Regards,
Saurabh Nandu
www.MasterCSharp.com
www.AksTech.com

SaurabhNandu at 2007-9-9 > top of Msdn Tech,Visual C#,Visual C# General...