You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I found a bug in your custom function z_jsonParseSupport1 at least when used with files CREATED with non english system settings:
jsonGet doesn´t work with floating point numbers.
Instead of 19.3277310924 the result is 193277310924 (the decimal point is missing)
It was difficult to find the point, as your file (created on an english system, I assume) works. (So does a file I created on with a different Mac OS X User with complete english settings at time of file creation)
What I have done:
Created a new file (1x on a german system / 1 x on an english system)
copied all custom functions from your FileMaker-JSON-Functions.fmp12
Run “Evaluate”
Result:
German file: 193277310924
English file: 19.3277310924
To correct this misbehavior theres a change in function id 130 needed:
Somewhere below stands
GetAsNumber ($~json.text)
change this to
GetAsText ($~json.text)
I think there must be a reason for GetAsNumber (probably further calculations with the result), so:
Is it save to change "GetAsNumber" to "GetAsText"?
The text was updated successfully, but these errors were encountered:
I found a bug in your custom function z_jsonParseSupport1 at least when used with files CREATED with non english system settings:
jsonGet doesn´t work with floating point numbers.
Instead of 19.3277310924 the result is 193277310924 (the decimal point is missing)
It was difficult to find the point, as your file (created on an english system, I assume) works. (So does a file I created on with a different Mac OS X User with complete english settings at time of file creation)
What I have done:
Result:
German file: 193277310924
English file: 19.3277310924
To correct this misbehavior theres a change in function id 130 needed:
Somewhere below stands
GetAsNumber ($~json.text)
change this to
GetAsText ($~json.text)
I think there must be a reason for GetAsNumber (probably further calculations with the result), so:
Is it save to change "GetAsNumber" to "GetAsText"?
The text was updated successfully, but these errors were encountered: