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

[Steve Onnis]

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

Taco   try this   <cfquery name="qInsert" datasource="dsnCCDB_testing">  UPDATE _temp_All_Datasources_Deduped  SET  levelFloor = RTRIM(LTRIM(LEFT([Street Address 1],PATINDEX('%_,%',[Street Address 1]))))    streetAddress1Copy = RTRIM(LTRIM(SUBSTRING([Street Address 1],PATINDEX('%_,%',[Street Address 1])+1,Len([Street Address 1])))) </cfquery>   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>   Regards Steve Onnis -----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