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