Help converting a txt log file into a table format

[Bushi]

I'm collecting logs of cheaters from a gaming server which detects them. I'm looking for a way to convert the txt file into some sort of table .. whether in html or excel format.. or even anything else if it comes to that!
Here is a sample of the log:
Fri Dec 07 18:46:45 2001 Name: [ECC]StealthFoX from WONID: 1794186 listed as detected of having OGC installed.
Fri Dec 07 21:44:19 2001 Name: CokEShardS from WONID: 1154814 listed as detected of having Flautz Wallhack installed.
Fri Dec 07 22:11:37 2001 Name: Maximus from WONID: 628574 listed as detected of having OGC installed.
Fri Dec 07 22:11:37 2001 Name: Maximus from WONID: 628574 listed as detected of having XQZ2 installed.
Sat Dec 08 01:17:05 2001 Name: DEATHCORPS IlIlIl from WONID: 777788 listed as detected of having XQZ2 installed.


I would like the table to have columns head headings: Name, Date, WONID, Cheat

Any idea's? or any place I can go for idea's?

 

[RedRooster]

Get a good text editor and do a bunch of search and replaces.
Search on "Name:" and replace it with ",Name:". Do that for each section you'd like to split it up into, then delete extra info, like the word "from" and whatnot. Then, once it's comma delimited, you can import it into Excel easily.

 

[alisajid]

If there's a tab between each of the fields in the text file then it should be pretty easy using any programming language. Just use any old string tokenizer to pick up each field. However, if that's not the case parse the text file line-by-line and each line word-by-word using a counter to check if you've read all the words in a column whilee comparing the current word against column key words such as "Name", etc.

If you know perl it should be a breeze, otherwise, I'm sure some Perl guru (I'm not one) would be able to fix it in a few seconds.