Yeah - I'm leaning towards the perl script now.. I just really didn't want to download and install Perl, remember how to do reg-ex parsing, plan-write-test-debug the script, fight the urge to make it the best lil text parser ever :-)
It just finished downloading.. Sigh.. Thanks for the responses :) Jeff -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 3:27 PM To: CF-Talk Subject: RE: text parsing tool I'd write a Perl script. It'll be pretty fast (much faster than CF), very easy to maintain (probably moreso that CF), and brainless to use. Just have it output the results in whatever format you need to import directly into SQL Server and your job will be cake. Heck, if you've got DBI module in there, you could have it import to SQL Server directly. barneyb > -----Original Message----- > From: Jeff Beer [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 27, 2003 12:09 PM > To: CF-Talk > Subject: OT: text parsing tool > > > I know I could do this with CF, or Perl, but there has to be a better > way. > > I have a bunch of 5mb files that I need to extract specific info from. > > The format is simple. I have a single "phrase" in multiple places > like > this: > > X-msg-id:xxxxxxxx > > where the "X-msg-id:" portion never changes, and the "xxx.." can be > either all integers, or, a space followed by all integers. I simply > need to grab the number after the colon and export it. If I can add > them to a SQL Server database, even better, but any export format > would be fine. > > Writing a perl script would be pretty easy, but I'm wondering if there > are any known text editors or other utilities that will make this > quick and easy. > > The files I need to parse are actually MS Exchange message tracking > log files, and every two or three days I have about 5 gigs total... > > Any ideas? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
