1 Reply Latest reply on Apr 12, 2013 10:01 AM by disabled_ntaylor

    Adding Spaces for post codes

    JustinEdwards

      Summary

      Adding Spaces for post codes

      Product

      FileMaker Pro

      Version

      11.0v4

      Operating system version

      10.7.4

      Description of the issue

      I'm trying to add spaces so the postcodes are always formatted correctly, is there any way to do this?

        • 1. Re: Adding Spaces for post codes

               Justin Edwards:

               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:

                

               Left

               (Filter (postcodefield ; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789") ; 3) & " " 

                

               &

                

               (Right

               (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.

                

               TSFalcon

               FileMaker, Inc.