FormatPostcodeNL ( TheCode )
Function for formatting dutch postcodes
Average rating: 4.3 (34 votes) Log in to vote
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.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.