Brian Dunning's FileMaker Custom Functions

FormatPostcodeNL ( TheCode )

Function for formatting dutch postcodes

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

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

Share on Facebook Share on Twitter

  Sample input:
FormatPostcodeNL ( "1234pc" )
  Sample output:
1234 PC

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

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

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.