TRY THIS: <cfset City = "St Louis"> <cfset Replacement = "Saint "> <cfoutput>#REReplace(City,"[sS][tT][\.| ]",Replacement)#</cfoutput>
To verify, place a "." after "St". HTH +--------------------------+---------------------------+ | 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: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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
