AnsweredAssumed Answered

Currency symbols in text fields do not sort

Question asked by CraftICT on Oct 7, 2014
Latest reply on Oct 7, 2014 by 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

Outcomes