NBusch

Localization error in GetAsNumber

Discussion created by NBusch on Jan 25, 2017
Latest reply on Jan 26, 2017 by NBusch

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

OS and version Windows 10

 

Description

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:

2017-01-25_12-17-21.png

Then check with GetAsNumber ("42.4567834")

 

 

Workaround (if any)

Outcomes