Snippets

Robert Waddell ColdFusion Address and Zip Parsing

Created by Robert Waddell last modified
<cfset loc.SOURCETEXT = "123 ABC Street, Any Town, MA 12345">

<cfset loc.array_zip_code = REMatchNoCase("[-:.\s][0-9]{5}([-][0-9]{4})?",loc.SOURCETEXT)>
<cfif ArrayLen(loc.array_zip_code) GT 0>
	<cfset loc.ZIP = REReplaceNoCase(loc.array_zip_code[1],"[-:.\s]","","All")>
	<b>ZIP:</b>
	<cfdump var="#loc.ZIP#">
</cfif>
<br><br>
<cfset loc.street_types = "STREET|ST|DRIVE|DR|AVENUE|AVE|ROAD|RD|LOOP|COURT|CT|CIR|CIRCLE|LANE|LN|BOULEVARD|BLVD">
<cfset loc.array_street_type = REMatchNoCase("(\s)+(#loc.street_types#)[^a-zA-Z]",loc.SOURCETEXT)>
<cfif ArrayLen(loc.array_street_type) GT 0>
	<cfset loc.street_address_trimmed = Left(loc.SOURCETEXT,FindNoCase(loc.array_street_type[1],loc.SOURCETEXT)+Len(loc.array_street_type[1]))>
	<cfset loc.array_street_address = REMatchNoCase("(\d{1,5})+(\s([a-zA-Z])+)+",loc.street_address_trimmed)>
	<cfif ArrayLen(loc.array_street_address) GT 0>
		<cfset loc.ADDRESS = loc.array_street_address[1]>
		<b>ADDRESS:</b>
		<cfdump var="#loc.ADDRESS#">
	</cfif>
</cfif>

Comments (0)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.