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? 12/30/2003 09:03:39.823 Qafdf020302588aad Test #78: BASICFILTER [filter] - may skip 12/30/2003 09:03:39.823 Qafcc023b02523f9a Test #54: SPMMGRSPAM2 [external] - may skip 12/30/2003 09:03:39.823 Qafe0021101d68bb7 Doing filter file C:\Imail\Declude\filters\keysubject.txt. 12/30/2003 09:03:39.980 Qafe0021001d68b3a Doing filter file C:\Imail\Declude\filters\_YDirected.txt. 12/30/2003 09:03:40.120 Qafdf020e01d68994 Doing filter file C:\Imail\Declude\filters\_YDirected.txt. 12/30/2003 09:03:40 Qafdf020202588a20 Filter: Set max weight to 10. 12/30/2003 09:03:40.120 Qafdf020f01d68a4f Finished Final Test #49: LONGSUBJECT2 [subjectchars] 12/30/2003 09:03:40.120 Qafdf020302588aad Test #79: GRAYFILTER4 [filter] - may skip 12/30/2003 09:03:40.120 Qafcc023b02523f9a SPMMGRSPAM2: External test using cached exit code of 0 [from SPMMGRSPAM1]. 12/30/2003 09:03:40 Qafe0021101d68bb7 Triggered CONTAINS filter KEYSUBJECT on son [weight->5; SonicWALL [RelianceSoft, Main]]. 12/30/2003 09:03:40 Qafdf020e01d68994 Filter YDIRECTED: Not skipping E-mail due to current weight of 15. 12/30/2003 09:03:40.277 Qafdf020202588a20 Doing filter file C:\Imail\Declude\filters\_YDirected.txt. 12/30/2003 09:03:40.277 Qafdf020f01d68a4f Test #50: SPAMDOMAINS [spamdomains] - may skip John Tolmachoff Engineer/Consultant/Owner eServices For You --- [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.