|
so
that would leave you with one value of "Annexe building" and another of "George
Street, Level 3"
With ones like that you would be wanting "Level 3 Annexe
building" and "George Street". Your gonna have to manually get those ones
out.
Correct, I showed a bad example
"Annexe building, George Street, Level 3"
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
---
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
|
