I've done both. And used perl. And gep/sed/awk solutions. The fastest, expandable, repeatable solution that wont choke a cf server that is being used for other things is the datasource solution.
But any will work. The question becomes: how often do you do this, who is going to run it, how changeable are the formats. On Wed, Apr 22, 2009 at 2:38 PM, Michael Grant <[email protected]> wrote: > > I think I'd have to disagree since he said the max size is about 1MB. > Looping over a 1MB text file where all you're doing is looking at the first > letter of an item in the list shouldn't be be slow at all. In fact I'd think > it would be done in the time it took you to mess around creating DSN > connections etc. Plus I always prefer programmatic vs. manual. > > This does pique my curiosity though. Ian, any chance you could post an > example of your largest text file so I/we could do some testing? > > > > On Wed, Apr 22, 2009 at 2:20 PM, Robert Munn <[email protected]> wrote: > >> >> I like this solution. Parsing large text files is going to be slow in CF >> relative to using a flat file ODBC driver. >> >> Check this out, should be easy on a Windows machine... >> >> http://www.herongyang.com/jdbc/JDBC-ODBC-Flat-Text-File.html >> >> >> >> >> >> On Wed, Apr 22, 2009 at 7:44 AM, Jerry Johnson <[email protected]> wrote: >> >> > >> > programmatically hook them up in coldfusion as datasources, and search >> > the column? >> > >> > >> > >> > On Wed, Apr 22, 2009 at 10:15 AM, Ian Skinner <[email protected]> wrote: >> > > >> > > You have a several dozen text files ranging in size from ~1KB to ~1MB >> > > each. These files are column delimited data files and you need to find >> > > records in any of the files that have an 'F' character at column 26. >> > > You have normal tools available on a Windows XP Pro computer and >> > > ColdFusion developer. How would you go about this quickly and >> > efficiently? >> > > >> > >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:295663 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
