Good Point. Try this instead. There is prolly a better Regular Expression than this, but it works :)
<cfset City = "East St. Louis"> <cfset Replacement = " Saint "> <cfoutput>#Trim(REReplace(City,"[ ][sS][tT][\.| ]",Replacement))#</cfoutput> +--------------------------+---------------------------+ | SCOTT VAN VLIET | SBC SERVICES, INC. | | Senior Analyst | ITO Enterprise Tools | | Tel: 858.886.3878 | 7337 Trade St. Room 4000 | | Pgr: 858.536.0070 | San Diego, CA 92121 | | Email: [EMAIL PROTECTED] | http://www.sbc.com | +--------------------------+---------------------------+ -----Original Message----- From: Jim Gurfein [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 2:42 PM To: CF-Talk Subject: RE: Wild Card Finding the "st" works fine with the list, however, when I do the replace, I get nailed when something like "East St Louis" comes up... it becomes "eaSaint Saint louis " What now? At 04:25 PM 4/18/02 -0500, you wrote: >Handle your string as a list with a space as your delimiter - compare >against each element in the list ("st" in a word won't be an element by >itself) > >--- >Billy Cravens > > >-----Original Message----- >From: Jim Gurfein [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 18, 2002 4:22 PM >To: CF-Talk >Subject: Wild Card > >I'm stumped... > >If a city is entered as "St Louis", I want to change it to "Saint >Louis". I >did <cfif city contains "st "> and did a replacement (note the space >after >"st". > >However, if I have a city such as "East Hartford" the "st " is changed >to >"saint" as well... essentially, I need to know if the "st" (or "st.") is > >stand alone and not preceded by any other letter. > >Any ideas? > >Sincerely yours, > >Jim Gurfein >President, CEO >RestaurantRow.com, Inc. >http://www.restaurantrow.com >914.921.3200 ext 101 >914.921.9190 fax > > > ______________________________________________________________________ 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
