You could also treat it like two lists right?
!--- read in the file --->
<CFFILE ACTION="READ" FILE="#TheFolder#\page-results.log" VARIABLE="sIn">
<!--- use this variable for your line delimiter weather it be char(10) or
whatever --->
<CFSET delimiter = char(10)>
<!--- create the array to hold the page numbers --->
<cfset arPages = arrayNew(listLen(sIN, delimiter))>
<!--- add the page numbers to the array --->
<cfloop from="1" to="#listLen(sIN, delimiter)#" index="i">
<cfset temp = listGetAt(sin,i, delimiter)>
<cfset arPages[i] = listGetAt(temp, 1, ">">
<cfloop>
Tim
-----Original Message-----
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 8:37 AM
To: CF-Talk
Subject: Re: Create dropdown selection from external files
I don't recall receiving your email. I probably deleted it by accident.
Your code worked great.
Thanks Seth
At 08:23 AM 6/3/2002 -0400, you wrote:
> > I have the following list from an external file that is being creating
>with
> > the <cfexecute tag.
> > What I would like to do (but not sure how) is to grab the page numbers
>from
> > the list ONLY and include them in the <select tag.
> >
> > Here is a snippet from the external file. This could be a few lines or a
> > few hundred. Depends on the job.
><snip>
> >
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > S U M M A R Y O F F O L I O S / L E A D
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > 001>folio: 165 . . . 011.50 points free
> > 002>folio: 166 . . . 007.00 points free
><snip>
>
>Last week I sent an answer to your problem to the list and directly to
>you... did you have troubles with my solution? Here it is again:
>
>You can use regular expressions to parse the page number from each line of
>the file. Here's the code you'll need:
>
><!--- read in the file --->
><CFFILE ACTION="READ"
> FILE="#TheFolder#\page-results.log"
> VARIABLE="sIn">
>
><!--- create the array of page nums --->
><CFSET arPages = ArrayNew(1)>
>
><!--- find lines like "001>folio: 165 . . . 011.50 points free" --->
><CFSET strCR = Chr(13) & Chr(10)>
><CFSET reLine = "([0-9]+>folio:[ ]+)([0-9]+)[::Graph::| ]+(#strCR#)?">
><CFSET stcLine = REFindNoCase(reLine, sIn, 1, True)>
><!--- loop through the line matches, pull out the page
> number and add it to the array --->
><CFLOOP CONDITION="#stcLine.pos[1]# NEQ 0">
> <CFSET strLine = Mid(sIn, stcLine.pos[1], stcLine.len[1])>
> <CFSET strPageNum = REReplaceNoCase(strLine, reLine, "\2", "ALL")>
> <CFSET result = ArrayAppend(arPages, strPageNum)>
> <!--- get the next match --->
> <CFSET stcLine = REFindNoCase(reLine, sIn,
stcLine.pos[1]+stcLine.len[1]-1,
>True)>
></CFLOOP>
>
><!--- you now have an array of the page numbers (arPages)
> from which you can populate your select box --->
><CFOUTPUT>
><select name="filelist" size="5" multiple>
> <CFLOOP INDEX="i" FROM="1" TO="#ArrayLen(arPages)#">
> <option value="#arPages[i]#">#arPages[i]#</option>
> </CFLOOP>
></select>
></CFOUTPUT>
>
>I tested everything except the select box building code on my own machine
>using a text file I created from your email. You should be able to copy
and
>paste the code directly into your application.
>
>Hope this helps,
>Seth Petry-Johnson
>Argo Enterprise and Associates
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
