Adding Spaces for post codes
I'm trying to add spaces so the postcodes are always formatted correctly, is there any way to do this?
Thank you for the post.
Various calculations can be used to achieve this result with FileMaker. One way is using a combination of the Filter function and the Left and Right functions. The calculation I used to recalculate on a postal code field follows:
(Filter (postcodefield ; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789") ; 3) & " "
(Filter (postcodefield ; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxy0123456789") ; 3 ) )
Note: The inspector was used to set the style on the field to UPPERCASE.
Please note that you are posting to the Report an Issue part of the forum. It is intended for posting possible bug reports. Had you posted this to the FM Pro Forum section (see tab at top of screen), your post would have been seen by more people and will most likely receive a quicker response.
Retrieving data ...