Tree Creative Ltd
Christchurch - New Zealand
http://www.matthewwalker.net.nz/
http://www.cabbagetree.co.nz/
*/
-Original Message-
From: Jim Gurfein [mailto:[EMAIL PROTECTED]]
Sent: Friday, 19 April 2002 9:53 a.m.
To: CF-Talk
Subject: RE: Wild Card
Works fine
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
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
Two functions, one way,
Check from the start of the string.
cfif left(city,3) eq st
Or go with a regular expression, which you could either pin to the start of string of
look for a space character before the st
Jerry
[EMAIL PROTECTED] 04/18/02 05:22PM
I'm stumped...
If a city is
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
: 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
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
Can you use case sensitive replacing?
- j
-Original Message-
From: Jim Gurfein [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 5: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
|
+--+---+
-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
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
|
+--+---+
-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
, 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
: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
]]
Sent: Friday, 19 April 2002 9:53 a.m.
To: CF-Talk
Subject: RE: Wild Card
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
14 matches
Mail list logo