Localization error in GetAsNumber

Discussion created by NBusch on Jan 25, 2017
Latest reply on Nov 14, 2018 by Ben

Product and version  FileMaker Advanced, Pro & Runtime 15 and 14

OS and version Windows 10



GetAsNumber() should always recognize the decimal delimiter in a given text, but fails to do so on a Swiss system


I stumbled upon this when I tried to write the latitude and longitude as returned by the google maps API into number fields in Filemaker. Google returns a string like "42.456123", but writing this into a field of the type number drops the decimal point. Likewise GetAsNumber ("42.4567834") should yield the value 42.4567834, instead FileMaker returns 424567834. If you use the same function without quotes, GetAsNumber (42.4567834), the correct value is returned.


How to replicate

Before starting FileMaker, add the language "German (Switzerland)" to your system settings and set your number formats to use this. The settings look like this:


Then check with GetAsNumber ("42.4567834")



Workaround (if any)