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)