Newest functions Upload a function Leave a tip My account

There are 2,638 functions in this library.

CanadaPostalCodeFix ( "input" )

Standardized formatting of inputted Canadian postal code to A1A 1A1

  Be the first to rate this function Log in to vote

RealGrouchy - Show more from this author https://realgrouchy.blogspot.com

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

/* PostalCodeFix by RealGrouchy. Submitted to Brian Dunning's website 2026-04-15 (but I created it probably over 10 years ago). This function takes user-provided input and attempts to convert it to Canadian postal code format A1A 1A1, ensuring all "A"s are uppercase letters, all "1"s are numbers, and there's a space between the two groups of 3. e.g. PostalCodeFix ( "a1a1a1" ) results in "A1A 1A1" If the entered input isn't consistent with a Canadian postal code, it will just return the input uppercase. */ Let ( [ pc_orig = TextFormatRemove ( Upper ( input ) ) ; pc = Substitute ( pc_orig ; [ ¶ ; "" ] ; [ " " ; "" ] ) ] ; /* If 6 digits ... */ If ( ( (Length ( pc ) = 6 ) ) /* And if it has 3 letters */ and ( Length ( Filter ( pc ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ) = 3 ) /* And it has 3 numbers */ and ( Length ( Filter ( pc ; "1234567890" ) ) = 3 ) ; /* Treat it as a Canadian postal code and format it as uppercase with a space. (Also works with some UK postal codes) */ Left ( pc ; 3) & " " & Right ( pc ; 3) ; /* Otherwise make it uppercase and remove formatting but otherwise leave as is (e.g. Australa, Bermuda, or UK postal codes) */ pc_orig ) // If ) // Let Click to copy

This function takes user-provided input and attempts to convert it to Canadian postal code format A1A 1A1, ensuring all "A"s are uppercase letters, all "1"s are numbers, and there's a space between the two groups of 3.

e.g. PostalCodeFix ( "a1a1a1" ) results in "A1A 1A1"

If the entered input isn't consistent with a Canadian postal code, it will just return the input uppercase.

 

Comments

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 22 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: