|
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"
What
does an original string look like?
I
loop over 13.000 records...
yeah I know, but how in godsname do you do a regex in MS SQL? I
haven't found how yet, if there is a HOW....
Maybe it could be done by working with SPs and call some objects, but
I haven't figured out how yet... ;-))
Are you applying
the regex to lots of strings like " ,
55 Harrington
Street" or to one big
string with lots of entries?
-----Original
Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur
Sent: Tuesday, 11 November 2003 2:53
p.m.
To: CFAussie Mailing
List
Subject: [cfaussie]
RE: RegEx..............
Nope, I still get
entries like
" ,
55 Harrington Street"
I ran a regex on
the string before, one that deletes everything but a-z0-9 and even that
left the space and comma in there, that's when I consulted this
list...
Like it did work
for most records but never for the same records...
-----Original
Message-----
From:
Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 11 November 2003
12:34 PM
To: CFAussie
Mailing List
Subject:
[cfaussie] RE: RegEx..............
How
about reReplace(address, “(^[[:space:],]+|[[:space:],]+$)”, “”, “ALL”)
?
-----Original
Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur
Sent: Tuesday, 11 November 2003
2:24 p.m.
To: CFAussie
Mailing List
Subject:
[cfaussie] RegEx..............
I have this RegEx <cfset
regEx = "\s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground
(floor|level))|\s*(floor|level)\s*\d*">
It is extracting LEVEL and
FLOOR information from 13.000 addresses, it works fine.
....................but
When I insert the remaining
ADDRESS part after the floor level extraction I end up with records
like
" ,
Lamington National Park Road "
", Lamington National Park
Road , "
I run an extra regex
<reReplace> on inserting the new address field, which
is
(\s*,)|($\s,)|$,|^\s
But it doesn't do any good,
I still end up with the records formatted like above.
Anyone?
Taco
Fleur
07 3535 5072
Tell me and I
will forget
Show me and I will remember
Teach me and I will
learn
---
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
|
