FormatPostcodeNL ( TheCode )

Function for formatting dutch postcodes

Average rating: 4.3 (34 votes) Log in to vote

Henk Brendel
Data 33
http://www.data33.nl

Sample input:

FormatPostcodeNL ( "1234pc" )

Sample output:

1234 PC

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

/*

Author: Henk Brendel | Data 33 | NL

This function formats dutch postcodes (4 digits followed by two characters).
The postcode will be returned as: <4 digits><space><2 capitalized characters>.
"1234pc" will be returned as "1234 PC"
"  78  54g Q" will be returned as "7854 GQ"
Postcodes that are not entered as 4 digits followed by two characters are considered to be foreign, and will remain unchanged.

*/

Let ( 
    [ 
    vNoSpaces = Substitute ( TheCode ; " " ; "" ) ; 
    vPart1 = Left ( vNoSpaces ; 4 ) ; 
    vPart2 = Right ( vNoSpaces ; 2 ) ; 
    vIsDutch = Case ( 
        Length ( vNoSpaces ) ≠ 6 ; 0 ; 
        Filter ( vPart1 ; "01234567890" ) ≠ vPart1 ; 0 ; 
        Filter ( vPart2 ; "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ≠ vPart2 ; 0 ; 
        1 
        ) 
    ] ; 

    If ( vIsDutch ; vPart1 & " " & Upper ( vPart2 ) ; TheCode ) 
)

This function formats dutch postcodes (4 digits followed by two characters).
The postcode will be returned as: 4 digits-space-2 capitalized characters.
"1234pc" will be returned as "1234 PC"
" 78 54g Q" will be returned as "7854 GQ"
Postcodes that are not entered as 4 digits followed by two characters are considered to be foreign, and will remain unchanged.

Comments

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

FormatPostcodeNL ( TheCode )

Comments

Support this website.

Support this website.