oops, that arrayappend is wrong. Should be:
<cfset ArrayAppend(Names,ListFirst(thisRow,' <'))/>
(since not all rows have a space between the name and <[num]> bit.
> *shrug* Almost did give a solution similar to that, but then decided
> to go for a regex one since that's what was specifically asked for.
> But reconsidering, I agree - I should've gone for the more readable
> one...
>
>
> <cfset Names = ArrayNew(1)/>
> <cfloop index="thisRow" list="#Data#" delimiters="#Chr(10)#">
> <cfif Find('<20>',thisRow)>
> <cfset ArrayAppend(Names, ListFirst(thisRow,' '))/>
> </cfif>
> </cfloop>
> <cfdump eval="Names"/>
>
>
> > Why wouldn't you just loop over the cfexecute's return using crlf as
>
> > the delim and a simple find("<20>",currentline) statement in the
> loop?
> > If true treat the currentline as a space delimned list and
> > trim(ListFirst(currentline," ")).
> >
> > Maybe not as elegant, but at least you can read it.
> >
> > Mik
> >
> >
> > At 05:02 PM 3/1/2007, Peter Boughton wrote:
> > >Not convinced this is the best way, but it works:
> > >
> > ><cfset Result = REReplace(Data,
> > '(\n([^<]*?)<([^2][0-9A-F]+|2[^0][0-9A-F]*|20[0-9A-F]+)>[^\n]*)+',',
> ',
> > 'all')/>
> > ><cfset Result = ListToArray(REReplace(Result,'\s*,\s*([^<\s]*)[^,
> ]*',
> > ',\1','all'))/>
> > >
> > >(First REReplace isolates any <20> lines, second one cuts out
> > non-name data and converts to array)
> > >
> > >
> > >
> > >> How would one of you regex skilled people find the name on the
> line
> >
> > >> that has a <20> in it, there maybe more then one line like this.
> > >>
> > >
> > >> Name Type Status
> > >>
> > >
> > >> ---------------------------------------------
> > >>
> > >
> > >> ISKINNER-SVR <00> UNIQUE Registered
> > >>
> > >
> > >> SMFNT <00> GROUP Registered
> > >>
> > >
> > >> ISKINNER-SVR <20> UNIQUE Registered
> > >>
> > >
> > >> ISKINNER-SVR <03> UNIQUE Registered
> > >>
> > >
> > >> SMFNT <1E> GROUP Registered
> > >>
> > >
> > >> INet~Services <1C> GROUP Registered
> > >>
> > >
> > >> IS~ISKINNER-SVR<00> UNIQUE Registered
> > >>
> > >
> > >> ISKINNER <03> UNIQUE Registered
> > >>
> > >
> > >> ISKINNER-SVR <01> UNIQUE Registered
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> --------------
> > >> Ian Skinner
> > >> Web Programmer
> > >> BloodSource
> > >> www.BloodSource.org
> > >> Sacramento, CA
> > >>
> > >> ---------
> > >> | 1 | |
> > >> --------- Binary Sudoku
> > >> | | |
> > >> ---------
> > >
> > >>
> > >> "C code. C code run. Run code run. Please!"
> > >> - Cynthia Dunning
> > >>
> > >> Confidentiality Notice: This message including any
> > >> attachments is for the sole use of the intended
> > >> recipient(s) and may contain confidential and privileged
> > >> information. Any unauthorized review, use, disclosure or
> > >> distribution is prohibited. If you are not the
> > >> intended recipient, please contact the sender and
> > >> delete any copies of this message.
> > >>
> > >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271224
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
