AddressLabel ( Name ; Address ; City ; State ; ZIP ; Country )

Address Labels - slide-up missing text in an address label

Average rating: 4.0 (36 votes) Log in to vote

Tony Tanevski - Show more from this author
Hi-Voltage
http://www.hi-voltage.com.au

Sample input:

AddressLabel("Frank Jones","33 Main St","Melbourne","VIC","3000","Australia")

Sample output:

Frank Jones
33 Main St
Melbourne, VIC 3000
Australia

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

Let(
[
    x1 = Name;
    x2 = x1 & Case(not IsEmpty(Address); Case(not IsEmpty(x1); "¶") & Address);
    x3 = Case(not IsEmpty(City); City & ", ") & Case(not IsEmpty(State); Upper ( State ) & " ") & ZIP;
    x4 = x2 & Case(not IsEmpty(x3); "¶") & x3;
    x5 = x4 & Case(not IsEmpty(country); Case( not IsEmpty(x4); "¶") & Country)
];

    x5

)

Correctly display text within an address label. Slide-up where necessary.

Comments

		Gjermund Gusland Thorsen, HELGEROA Feb 18, 2009
I like this idea, anyone started to collect rules for different countries? This function can really turn into a monsterous set of case statements :-)

		Nightmare, Your Doom May 25, 2015
Dnuuidaihwbdihbdiabcihdwbcihwdbihcbadihcbhiadbchiadbcabcidhacbhwddbchdwbchibdwchbdwcbwdhbhwdbchdwbhdqbchdqbihcbdqihcbdqihcbqdycbyqdbfydqbcyqdbcydwbcyddwbdwybdqydqydqybfuckyouihhniwdbhiwdihabhiadbhicabiadbcihdacihabihdcbaihdhbiqihcdqbihcqdbcihdwbihcdwbhiwdiwdichwdbhicbwduhcdbihwbwdhbihdwbcidnwdnihdwncihwbciwdhbcidhwbcihwdbhidwbihwbihwbdhiwdbwhidbhwdibwihbdwchiwdbhidbwhidbwhcbdwhibihdwbcihwbdihbdwibdwihbwdihbwdhicbwdhidwbihdwibhdwhbiwdibhdwihwdbihwdibhiwhdbiwdhbbhdwhbwdhbwdhwdbhwdihbwduhwbduhbwdubhwdhbuwdubhdwuhbdw

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

AddressLabel ( Name ; Address ; City ; State ; ZIP ; Country )

Comments

Support this website.

Support this website.