|
If
your putting the values into seperate columns, why would you want to keep the
comma anyway?
Sorry Guys,
didn't ignore the proposed solutions or anything, just been
busy..
I
had a look at your proposed solution, but would that not remove the comma
from entries like "Makerston Street , Level 8" as
well?
-----------------------
maybe do a select first thought just to make sure its giving you what
you want
<cfquery name="qSelect"
datasource="dsnCCDB_testing">
SELECT levelFloor =
RTRIM(LTRIM(LEFT([Street Address 1],PATINDEX('%_,%',[Street Address 1])))) AS
Level,
streetAddress1Copy = RTRIM(LTRIM(SUBSTRING([Street Address
1],PATINDEX('%_,%',[Street Address 1])+1,Len([Street Address 1])))) AS
StreetAddress
FROM _temp_All_Datasources_Deduped
</cfquery>
-----------------------
Anyway, I decided those few records out of the
13.000 will just have be cleansed manually at some
stage...
.........weird
though..
Thanks
How did you go with this Taco?
"Level 2"
"55 Harrington Street"
So what is
"
Level 2, 55 Harrington Street,"
suposed to end
up looking like?
yes it should, but it isn't....
Like I said, I even tried replace [^a-z0-9] i.e. replace
anything not alphanumeric, which worked fine except on the problem
rows..... And it just doesn't make any sense.
So
reReplace(address, �^[[:space:],]+�, ��, �ALL�) should
catch the leading spaces and commas, and reReplace(address,
�[[:space:],]+$ �, ��, �ALL�) should
catch the trailing, right?
-----Original
Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Taco
Fleur
Sent:
Tuesday, 11 November 2003 4:04 p.m.
To: CFAussie Mailing
List
Subject:
[cfaussie] RE: RegEx..............
some of the
original strings that I am having issues with look
like
"
Level 2, 55 Harrington Street,"
" LEVEL
17, 175 EAGLE ST,"
" Level
2, 38 York Street"
---
You are
currently subscribed to cfaussie as: [EMAIL PROTECTED]
To
unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon
AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February,
2004 ---
You are currently subscribed to cfaussie as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon
AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon
AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon
AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
|
