Same problem... East St Louis results in "EaSaint St Louis"
At 02:37 PM 4/18/02 -0700, you wrote:
>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
>
>
>
______________________________________________________________________
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
