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 > > > > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
