John, If you need to do more that group by e-mail, what I do is to import the log into SQL2000 as a single column and then parse it with a T-SQL script using keywords, key phrases, unique characters and spaces in specific locations. Works really well and very fast.
George > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of John > Tolmachoff (Lists) > Sent: Tuesday, December 30, 2003 2:56 PM > To: [EMAIL PROTECTED] > Subject: RE: [Declude.JunkMail] Sorting log > > > That got it, thanks. > > John Tolmachoff > Engineer/Consultant/Owner > eServices For You > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:Declude.JunkMail- > > [EMAIL PROTECTED] On Behalf Of R. Scott Perry > > Sent: Tuesday, December 30, 2003 11:32 AM > > To: [EMAIL PROTECTED] > > Subject: Re: [Declude.JunkMail] Sorting log > > > > > > >I need to sort a debug log to find all lines for a message. > > > > > >Problem is, some lines include just seconds of time, some include > > thousands > > >of seconds. This is making it difficult to import into > Excel. Can't use > > >space as the delimiter. Can't use fixed width. Can't use tab. > > > > > >Any ideas on the fastest way to do this? > > > > You're using the debug mode, which isn't designed to be > processed in any > > way (aside from combining all lines with the same spool > file name). The > > debug mode log file entries include the milliseconds (for debugging > > purposes <G>). > > > > If you are just looking for all lines for a message, you can use: > > > > FIND "afe0021101d68bb7" dec####.log /i > > > > > > -Scott > > --- > > Declude JunkMail: The advanced anti-spam solution for IMail > mailservers. > > Declude Virus: Catches known viruses and is the leader in mailserver > > vulnerability detection. > > Find out what you've been missing: Ask about our free > 30-day evaluation. > > > > --- > > [This E-mail was scanned for viruses by Declude Virus > > (http://www.declude.com)] > > > > --- > > This E-mail came from the Declude.JunkMail mailing list. To > > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > > type "unsubscribe Declude.JunkMail". The archives can be found > > at http://www.mail-archive.com. > > --- > [This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)] --- This E-mail came from the Declude.JunkMail mailing list. To unsubscribe, just send an E-mail to [EMAIL PROTECTED], and type "unsubscribe Declude.JunkMail". The archives can be found at http://www.mail-archive.com. --- [This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)] --- This E-mail came from the Declude.JunkMail mailing list. To unsubscribe, just send an E-mail to [EMAIL PROTECTED], and type "unsubscribe Declude.JunkMail". The archives can be found at http://www.mail-archive.com.
