<cfset myString = ReReplaceNoCase(myString,"[ ](st)[\.| ]"," Saint ","ALL")> <cfset myString = ReReplaceNoCase(myString,"^(st)[\.| ]"," Saint ","ALL")>
How about that then.... Marlon ----- Original Message ----- From: "Jim Gurfein" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 4:55 PM Subject: Re: Wild Card > Nope, sorry... > East st. Louis ==>East st. Louis > St Louis==> Saint Louis > > > > At 04:45 PM 4/18/02 -0500, you wrote: > >ReReplaceNoCase(myString,"^st[\.| ]","Saint ","ALL") > > > >This will replace a string beginning with "st" only, so if you have an > >abbreviation for Street (st) in the rest of the string, it will not change > >it. > > > >Marlon > > > >----- Original Message ----- > >From: "Jim Gurfein" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Thursday, April 18, 2002 4:22 PM > >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 > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
