|
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
|
