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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
