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:295644 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
