[cfaussie] RE: RegEx..............

[Taco Fleur]

Title: RegEx..............

Nope, I still get entries like "    , 55 Harrington Street" " , 80 William St           " "1 Eagle 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