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
