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"
-----Original Message-----
From: Steve Onnis
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, 11 November 2003
1:46 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE:
RegEx..............
What does an original string look like?
-----Original Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Taco Fleur
Sent: Tuesday, November 11, 2003
2:20 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE:
RegEx..............
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... ;-))
-----Original Message-----
From: Matthew Walker
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, 11 November 2003
1:01 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE:
RegEx..............
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
---
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
|
