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

[Taco Fleur]

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

Sorry Guys,   didn't ignore the proposed solutions or anything, just been busy..   I had a look at your proposed solution, but would that not remove the comma from entries like "Makerston Street , Level 8" as well?   ----------------------- maybe do a select first thought just to make sure its giving you what you want   <cfquery name="qSelect" datasource="dsnCCDB_testing">  SELECT levelFloor = RTRIM(LTRIM(LEFT([Street Address 1],PATINDEX('%_,%',[Street Address 1])))) AS Level,                 streetAddress1Copy = RTRIM(LTRIM(SUBSTRING([Street Address 1],PATINDEX('%_,%',[Street Address 1])+1,Len([Street Address 1])))) AS StreetAddress FROM     _temp_All_Datasources_Deduped </cfquery> -----------------------   Anyway, I decided those few records out of the 13.000 will just have be cleansed manually at some stage... .........weird though..   Thanks   -----Original Message----- From: Steve Onnis [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 November 2003 1:54 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.............. How did you go with this Taco? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco Fleur Sent: Tuesday, November 11, 2003 4:01 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.............. "Level 2" "55 Harrington Street" -----Original Message----- From: Steve Onnis [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 2:57 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.............. So what is   "     Level 2, 55 Harrington Street,"   suposed to end up looking like? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco Fleur Sent: Tuesday, November 11, 2003 3:27 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.............. yes it should, but it isn't....   Like I said, I even tried replace [^a-z0-9] i.e. replace anything not alphanumeric, which worked fine except on the problem rows..... And it just doesn't make any sense. -----Original Message----- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 2:16 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.............. 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"     --- 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