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