That ones easy you need to just use the mid function, start with the first
number in the column definition, and then go to the end of the column.
<CFSCRIPT>
thisVar = mid(listGetAt(yourFileVariable, i, chr(13)), 1, 9);
</CFSCRIPT>
This will return the variable in column one of row one. If you need to loop
through to get all the rows treat it like a list with chr(13) as the
delimiter. You should also be able to do something similar to return an
actual query set using the query functions. I am not sure but you may also
be able to set it up as a datasource. I have heard of it working for comma
and tab delimited files, just not fixed width. Let me know if it works
please, I would like to try it some time.
Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 22, 2002 3:55 PM
> To: CF-Talk
> Subject: querying funky text files
>
>
> I've done it again. I've underbid on a project that's tured out
> to be a monster.
>
> I have to query a text file that has fixed-width columns. Anyone
> pulled this off before?
>
> Help.
>
> singed
> Brain Fried
> Nick
>
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
