Brian Dunning's FileMaker Custom Functions

fnAddressParser ( address ; type )

This CF parses address parts, allowing developers to create calculation fields for single address fields for display and sorting.

  Average rating: 4.4 (38 votes) Log in to vote

Andrew Butt   Andrew Butt
Drewsol
http://www.drewsol.com

Share on Facebook Share on Twitter

  Sample input:
fnAddressParser ( "123 W. 3rd St. #12, Los Angeles, CA 90040" , "Street" )

fnAddressParser ( "123 W. 3rd St. #12, Los Angeles, CA 90040" , "StreetSort" )

fnAddressParser ( "
Drew Wesley
Drewsol
123 W. 3rd St. #12
Los Angeles, CA 90040
" , "City" )
  Sample output:
W. 3rd St.


003 St., #21


Los Angeles

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This CF parses address parts, allowing developers to create calculation fields for single address fields for display and sorting.

 

Comments

David Graham   David Graham, San Diego, CA
Oct 2, 2009
I don't get the whole point behind the trademark symbol in Drewsol's function names. Is the author claiming that the name of the function uniquely identifies his business?

I see nothing unique in the name of this author's custom function names to warrant common law protection. In addition, the product itself is released under open-source license, so it baffles me that the author would seek to protect the name of a product that the author has released ownership rights to. Color me puzzled?!?!?

Dave Graham
dave at bittailor dot com
 
CA   CA, Cincinnati
Oct 29, 2009
//http://en.wikipedia.org/wiki/Street_name#Street_type_designations

Does this not include 'Court'
 
Drew Wesley   Drew Wesley, Los Angeles, CA
Oct 30, 2009
Now it does!
 
Christian Sauve   Christian Sauve, Montreal
Jul 26, 2013
Great function!
 
Rani Taylor   Rani Taylor, Frederick, MD
Sep 20, 2013
Is there a way to include the "Unit type" when parsing out the unit number? i.e. "Apt. 345 "instead of "345". I was hoping to use this to separate Primary address info from secondary.
 
Drew Wesley   Drew Wesley, Los Angeles, CA
Sep 20, 2013
@Rani - I just updated the function. Use "unit_type" as the parameter. :)
@Christian - Thanks!
 
Craig Watson   Craig Watson, Kailua Kona /Hawaii
Jan 22, 2014
Thanks for this function. I am a little lost which type selection to use parse an address so it
fits in a standard 6 field address line.
For example 731 S. Lewis st Apt 34
I need each item individually
731
S
Lewis
ST
Apt
34
I can get the 731 with "address_Number"
I can get the S with "Direction_prefix_v1"
I can get the 34 with "Unit"
Unable to get street name alone without the direction, the unit type (using("unit_Type") and street type (St.)
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.