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 > > ______________________________________________________________________ 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
