Whoops, I just re-read your post. I thought you said "comma delimited" not "column delimited." In that case you are going to have to use tab as your delimiter in the ListGetAt function.
UPDATED: <cffile action="read" file="C:\myFile.txt" variable="myTxt"> <cfset myRecords = ArrayNew(1)> <cfloop list="#mxTxt#" index="x" delimiters="#CHR(13)#"> <cfif Left(Trim(ListGetAt(x,26,CHR(9))),1) EQ "F"> <cfset myRecords = ArrayAppend(myRecords,x)> </cfif> </cfloop> On Wed, Apr 22, 2009 at 10:53 AM, Michael Grant <mgr...@modus.bz> wrote: > I think I'd skip the datasource part and just loop. > > <cffile action="read" file="C:\myFile.txt" variable="myTxt"> > <cfset myRecords = ArrayNew(1)> > <cfloop list="#mxTxt#" index="x" delimiters="#CHR(13)#"> > <cfif Left(Trim(ListGetAt(x,26)),1) EQ "F"> > <cfset myRecords = ArrayAppend(myRecords,x)> > </cfif> > </cfloop> > > > On Wed, Apr 22, 2009 at 10:44 AM, Jerry Johnson <jmi...@gmail.com> wrote: > >> >> programmatically hook them up in coldfusion as datasources, and search >> the column? >> >> >> >> On Wed, Apr 22, 2009 at 10:15 AM, Ian Skinner <h...@ilsweb.com> 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:295610 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5