2 Replies Latest reply on Oct 7, 2014 6:43 AM by CraftICT

    Currency symbols in text fields do not sort

    CraftICT

      Summary

      Currency symbols in text fields do not sort

      Product

      FileMaker Pro

      Version

      v13.0v3

      Operating system version

      Mac OS X 10.9.5 and Windows 8.1

      Description of the issue

      Working on sub summary reports in our multi-currency insurance database revealed that FMP will not sort currency symbols

      Steps to reproduce the problem

      Create a new blank file with 1 text field. Enter 4 records containing $, £, $, £ and try to sort them

      Expected result

      Either $, $, £, £ or £, £, $, $ ($ has the lowest unicode value)

      Actual result

      $, £, $, £

      Workaround

      We now have to bring the international 3 letter codes in from another table, such as USD and GBP and sort on these, or do a cross table sort

      FMP_Currency_Sort.jpg