SetFullAddress ( street1 ; street2 ; city ; state ; zip )
Simple function to build a full address from separate address fields. Currently only configured for US type addresses.
Average rating: 5.0 (1 vote) Log in to vote
Robert D Trammel - Show more from this author
Harmonic Software Production Studios
2) SetFullAddress ( "123 Easy St." ; "" ; "Dallas" ; "TX" ; "" )
2) 123 Easy St, Dallas, TX
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Get a fully formatted address without the need to rewrite the calculation every time you have to concatenate street address information. This takes into account missing values, etc.
May 20, 2022
|There is a much easier way to accomplish this...
Ignoring all of the Proper and Trim stuff, try this...
Substitute (List (City; State); "¶"; ", ");
If you want Address_1 and Address_2 on the same line, put in the same code as the City and State fields use. Much easier to account for missing entries as the List function ignores them.
|Robert D Trammel, Harmonic Software Production Studios
May 20, 2022
|Agh. I knew there was an easier way to do it. Thanks David.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.