Thanks to everyone who answered... Matthew's solution worked with 1 minor modification: #Ltrim(REReplaceNoCase(City ,"(^| )st\.? "," Saint "))#
You're all terrific! At 10:10 AM 4/19/2002 +1200, you wrote: >#REReplaceNoCase(City ,"(^| )st\.? "," Saint ")# > >Regards, >Matthew Walker >/* > Cabbage Tree Creative Ltd > Christchurch - New Zealand > > http://www.matthewwalker.net.nz/ > http://www.cabbagetree.co.nz/ >*/ > > >-----Original Message----- >From: Jim Gurfein [mailto:[EMAIL PROTECTED]] >Sent: Friday, 19 April 2002 9:53 a.m. >To: CF-Talk >Subject: RE: Wild Card > > >Works fine for "East St. Louis" but now does not work for "St. Louis" >Oh me! > >At 02:46 PM 4/18/02 -0700, you wrote: > >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
