Oh, fixed width? heck, that probably makes it even easier. Just use Mid() to get at your value instead of list get at. In fact that even makes a better argument for the regex.
the tens of thousands of records is no biggie either. My test bed was 150k. Just loop it with either a list of the filenames or use cfdirectory and loop over that. On Wed, Apr 22, 2009 at 4:40 PM, Ian Skinner <[email protected]> wrote: > > Michael Grant wrote: > > Ok, well this made me want to check it out so I did. I dumped one of my > > database tables with 149,517 records into a flat text file that was tab > > delimited. The total size was 20,546KB (20MB). > > I want to jump in here and say that this data is *not* tab delimited. > It is column delimited. I.E. characters 1-4 are one value, characters > 5-10 are another value, character 6 is a third and so on. Really old > school this data is. And I may need to examine tens of thousands of > records contained in dozens of files to see find which records in which > file contain a value of 'F' at character (aka column) 26. > > I have been noting the great suggestions and plan to look over them when > and I need to do this and|or have some spare time to play with it. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:295713 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
