Is there a delimited in the list of names (work_string), something that
you can include in your reg ex to "anchor" it to an entire entry? 
        Mark

-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 27, 2007 5:27 AM
To: CF-Talk
Subject: Regex help looking for a name in a string.

Ok, no doubt this is an easy RegEx question, but not for me.
 
I have two queries. One returns a set of names, the other a string which
may or may not contain one or more of the names.
 
I want to check for the existence of a name in the string, and if I find
it, make it a hyperlink.
 
So far I have this:
 
<cfset works_string = qry_getEvent.works>
 
<cfloop query="qry_getProfiles">
 <cfset works_string = REReplaceNoCase(#works_string#, #artist#, "<a
href='profiles.cfm?e=#profileID#' target='artistWin'>#artist#</a>",
"ALL")> </cfloop>
 
Which works in a limited sense but stumbles where names are similar or
contain the same words - for example
 
John Smith
John Smith & Sons
 
If the string contained John Smith & Sons, the code would highlight the
John Smith part but not the rest.
 
Any suggestions?
 
Thanks
 
will
 




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276380
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to