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

[Taco Fleur]

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

<cfsetting requesttimeout="800">   <cfquery name="qOrganisation" datasource="dsnCCDB_testing"> SELECT   [Street Address 1] AS addressline1,     TempID FROM   _temp_All_Datasources_Deduped WHERE   (NOT ([Street Address 1] IS NULL)) AND    (levelFloor IS NULL) ORDER BY   [Street Address 1] </cfquery>   <cfset regEx = "\s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d*">   <cfloop query="qOrganisation">   <cfset found = refindNocase(variables.regEx, qOrganisation.Addressline1, 1, "true")>   <!--- a bit messy ---> <cfset address = trim(reReplaceNoCase(qOrganisation.Addressline1, variables.regEx, ""))> <cfset address = trim(reReplaceNoCase(trim(variables.address), "(^[[:space:],]+|[[:space:],]+$)", ""))>   <cftry> <cfquery name="qInsert" datasource="dsnCCDB_testing"> UPDATE   _temp_All_Datasources_Deduped SET    levelFloor = '#lcase(trim(mid(qOrganisation.Addressline1, found.pos[1], found.len[1])))#',     streetAddress1Copy = '#variables.address#' WHERE   (TempID = #qOrganisation.TempID#) </cfquery>  <cfcatch></cfcatch> </cftry>   </cfloop> --- 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