DaniWeb Forum Index > Software Development > C#

Parsing a log file using regular expressions

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2006

Posts: 116

Reputation: bhavna_816 is an unknown quantity at this point

Solved Threads: 0

bhavna_816 bhavna_816 is offline

Offline

Junior Poster

Parsing a log file using regular expressions

Jun 25th, 2007

I have a text file say log file. i have to extract all the characters between "<" sign and ">" sign.
i.e. between <> and put it into the database and log file is of kind
Sun, 24 Jun 2007 21:49:49 GMT: Received request </abc/abc.gif>, from <111.1.11.11>:<1111> at domain <localhost/abc.net>
Sun, 24 Jun 2007 21:49:49 GMT: UserName <abc>, Proxy <localhost-80>, URN <http://abc/abc.gif>
Sun, 24 Jun 2007 21:49:49 GMT: Processing Proxy request
Sun, 24 Jun 2007 21:49:50 GMT: Sending Msg <111> from Proxy Reader <1111111111> for URL <http://abc.abc/>with Params <> <abc>
Sun, 24 Jun 2007 21:49:50 GMT: Named pipe <\\.\pipe\1111111111> started for request <http://abc.abc/>
Sun, 24 Jun 2007 21:49:50 GMT: Received request </abc/abc.gif>, from <111.1.11.11>:<1111> at domain <localhost/abc.net>
Sun, 24 Jun 2007 21:49:50 GMT: UserName <abc>, Proxy <localhost-80>, URN <http://abc/abc.gif>
Sun, 24 Jun 2007 21:49:50 GMT: Processing Proxy request
Sun, 24 Jun 2007 21:49:52 GMT: Received Msg <222> for URL <http://abc.abc/>
Sun, 24 Jun 2007 21:49:52 GMT: Status: 200 OK, Reminder: Server: Microsoft-IIS/5.1
X-Powered-By: ASP.NET
Date: Mon, 25 Jun 2007 04:48:33 GMT
Content-Type: text/html
Accept-Ranges: bytes
Last-Modified: Thu, 22 Mar 2007 05:29:17 GMT
Sun, 24 Jun 2007 21:49:52 GMT: Last chunck read from pipe \\.\pipe\1111111111 for <http://abc.abc/>: <963>
Sun, 24 Jun 2007 21:49:52 GMT: Closing pipe <\\.\pipe\1111111111> for url <http://abc.abc/>

and i want to parse this file and extract and put the information from <> sign into the database
i had followed following link for file parsing
and instead of putting the info in dataset i m putting it into database.
Now my problem is my log file is of above format and i have to parse all the info within <>
I m using C# 1.1 version
does anybody have any idea or suggestions?
Thanks in advance

•

Join Date: Aug 2005

Posts: 5,273

Reputation: iamthwee is a splendid one to behold

Solved Threads: 378

iamthwee

Offline

Posting Expert

Re: Parsing a log file using regular expressions

Jun 25th, 2007

Help with Code Tags

(Toggle Plain Text)

<.+?>

Last edited by iamthwee; Jun 25th, 2007 at 2:31 pm.

*Voted best profile in the world*

•

Join Date: Jun 2006

Posts: 7,648

Reputation: ~s.o.s~ has much to be proud of

Solved Threads: 474

~s.o.s~

Offline

Failure as a human

Re: Parsing a log file using regular expressions

Jun 25th, 2007

This <([^>]+)> would probably be what you were looking for. Since I don't know the C# Regex API (neither C#), I can't help you in that area, but as long as you know how to use back-references and extract the matched text, this shouldn't be a major problem.

For some tutorials on C# regexes see here.

Last edited by ~s.o.s~; Jun 25th, 2007 at 3:46 pm.

I don't accept change; I don't deserve to live.

Jo Tujhe Jagaaye, Nindein Teri Udaaye Khwaab Hai Sachcha Wahi.
Nindon Mein Jo Aaye Jise To Bhul Jaaye Khawab Woh Sachcha Nahi.
Khwaab Ko Raag De, Nind Ko Aag De

•

Join Date: Aug 2008

Posts: 2

Reputation: Muhammad Afnan is an unknown quantity at this point

Solved Threads: 0

Muhammad Afnan Muhammad Afnan is offline

Offline

Newbie Poster

Re: Parsing a log file using regular expressions

Aug 24th, 2008

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
Regex r;
            Match m;
            string inputString = "sdasdsf < Muhammad > dffafsdfsfssd < Afnan > fdgdfsagff <Khan> sdsdf dssdsdfsdsdfsdf<lastafnan@hotmail.com>sdfsdfsdffsdsdfsdfsdffsdfsdfsd";
 
            r = new Regex("(<.+?>)", RegexOptions.IgnoreCase | RegexOptions.Compiled);
            for (m = r.Match(inputString); m.Success; m = m.NextMatch())
            {
                Console.WriteLine("Found:" + m.Groups[1] + "at" + m.Groups[1].Index);
            }
            Console.ReadLine();
Regex r;
            Match m;
            string inputString = "sdasdsf < Muhammad > dffafsdfsfssd < Afnan > fdgdfsagff <Khan> sdsdf dssdsdfsdsdfsdf<lastafnan@hotmail.com>sdfsdfsdffsdsdfsdfsdffsdfsdfsd";

            r = new Regex("(<.+?>)", RegexOptions.IgnoreCase | RegexOptions.Compiled);
            for (m = r.Match(inputString); m.Success; m = m.NextMatch())
            {
                Console.WriteLine("Found:" + m.Groups[1] + "at" + m.Groups[1].Index);
            }
            Console.ReadLine();

Last edited by ~s.o.s~; Aug 24th, 2008 at 5:50 am. Reason: Added code tags, learn to use them.

Quick Reply to Thread

Show Printable Version

Similar Threads

Open In New Window Php (PHP)
In Desperate Need of Help with hijack this log file; computer full of spyware (Viruses, Spyware and other Nasties)
HiJackThis Log File... (Viruses, Spyware and other Nasties)
Bridge.dll error please help me here is my hijackthis log file! (Viruses, Spyware and other Nasties)
ANOTHER hijackthis log file..help! (res://mshp.dll, lookfor.cc) (Viruses, Spyware and other Nasties)
HijackThis log file (Viruses, Spyware and other Nasties)

Other Threads in the C# Forum

Previous Thread: how to count?
Next Thread: EvenOdd

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes