Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Creates a new JSON encoded number.

Component Version macOS Windows Linux Server iOS SDK
JSON 2.7 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "JSON.CreateNumber"; value )   More


Parameter Description Example
value The number value. 123.4


Returns JSON code.


Creates a new JSON encoded number.
Version 10.0 or newer preserve formatting if you pass a text with a number containing digits with optionally one dot and one minus.
Returns NULL if you pass empty text.


Creates a number:

MBS( "JSON.CreateNumber"; 123 )

Example result: 123

Create big number:

MBS( "JSON.CreateNumber"; 12063660878882855000013426248015578834577 )

Pass through vs. number parsing:

MBS( "JSON.CreateNumber"; "123.5" ) & ¶ & MBS( "JSON.CreateNumber"; 123,5 )
// in German with comma as separator second one is parsed as double precision value.

Example result:

See also

Release notes

Example Databases

Blog Entries

This function is free to use.

Created 18th August 2014, last changed 7th December 2021

JSON.CreateNull - JSON.CreateObject