BinToFloat32IEEE ( binary )

Convert a float32 (IEEE-754) formatted binary string to a decimal number.

Average rating: 4.3 (7 votes) Log in to vote

Arjen van Dijk - Show more from this author
KROHNE Altometer

Sample input:

BinToFloat32IEEE ( "11000011000110010011100111010010" )

Sample output:

-153.225860595703125

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
CUSTOM FUNCTION: BinToFloat32IEEE ( binary )
© 2018 Arjen van Dijk, avdijk128@kpnmail.com

Convert a float32 (IEEE-754) formatted binary string to a decimal number.

EXAMPLES:

   BinToFloat32IEEE ( "01000001110010000000000000000000" ) // -->  25
   BinToFloat32IEEE ( "00111111100000000000000000000000" ) // -->  1
   BinToFloat32IEEE ( "10111110100000000000000000000000" ) // -->  -.25
   BinToFloat32IEEE ( "11000001000111111111111111111100" ) // -->  -9.999996185302734375
   BinToFloat32IEEE ( "11000011000110010011100111010010" ) // -->  -153.225860595703125

IMPLEMENTATION: Requires Bin2Dec

LAST MODIFIED: 27-Jun-2018 by Arjen van Dijk
*/

(
-1  ^ Middle ( binary; 1; 1)) *
(1+
Case ( (Middle(binary;10;1) =1) ; SetPrecision (2 ^ -1 ; 400) ; 0 ) +
Case ( (Middle(binary;11;1) =1) ; SetPrecision (2 ^ -2 ; 400) ; 0 ) +
Case ( (Middle(binary;12;1) =1) ; SetPrecision (2 ^ -3 ; 400) ; 0 ) +
Case ( (Middle(binary;13;1) =1) ; SetPrecision (2 ^ -4 ; 400) ; 0 ) +
Case ( (Middle(binary;14;1) =1) ; SetPrecision (2 ^ -5 ; 400) ; 0 ) +
Case ( (Middle(binary;15;1) =1) ; SetPrecision (2 ^ -6 ; 400) ; 0 ) +
Case ( (Middle(binary;16;1) =1) ; SetPrecision (2 ^ -7 ; 400) ; 0 ) +
Case ( (Middle(binary;17;1) =1) ; SetPrecision (2 ^ -8 ; 400) ; 0 ) +
Case ( (Middle(binary;18;1) =1) ; SetPrecision (2 ^ -9 ; 400) ; 0 ) +
Case ( (Middle(binary;19;1) =1) ; SetPrecision (2 ^ -10 ; 400) ; 0 ) +
Case ( (Middle(binary;20;1) =1) ; SetPrecision (2 ^ -11 ; 400) ; 0 ) +
Case ( (Middle(binary;21;1) =1) ; SetPrecision (2 ^ -12 ; 400) ; 0 ) +
Case ( (Middle(binary;22;1) =1) ; SetPrecision (2 ^ -13 ; 400) ; 0 ) +
Case ( (Middle(binary;23;1) =1) ; SetPrecision (2 ^ -14 ; 400) ; 0 ) +
Case ( (Middle(binary;24;1) =1) ; SetPrecision (2 ^ -15 ; 400) ; 0 ) +
Case ( (Middle(binary;25;1) =1) ; SetPrecision (2 ^ -16 ; 400) ; 0 ) +
Case ( (Middle(binary;26;1) =1) ; SetPrecision (2 ^ -17 ; 400) ; 0 ) +
Case ( (Middle(binary;27;1) =1) ; SetPrecision (2 ^ -18 ; 400) ; 0 ) +
Case ( (Middle(binary;28;1) =1) ; SetPrecision (2 ^ -19 ; 400) ; 0 ) +
Case ( (Middle(binary;29;1) =1) ; SetPrecision (2 ^ -20 ; 400) ; 0 ) +
Case ( (Middle(binary;30;1) =1) ; SetPrecision (2 ^ -21 ; 400) ; 0 ) +
Case ( (Middle(binary;31;1) =1) ; SetPrecision (2 ^ -22 ; 400) ; 0 ) +
Case ( (Middle(binary;32;1) =1) ; SetPrecision (2 ^ -23 ; 400) ; 0 )) *
(
SetPrecision ((2 ^ (Bin2Dec ((Middle(binary;2;8));0)-127));400)
)

CUSTOM FUNCTION: BinToFloat32IEEE ( binary )
© 2018 Arjen van Dijk, avdijk128@kpnmail.com

Convert a float32 (IEEE-754) formatted binary string to a decimal number.

EXAMPLES:

BinToFloat32IEEE ( "01000001110010000000000000000000" ) // --> 25
BinToFloat32IEEE ( "00111111100000000000000000000000" ) // --> 1
BinToFloat32IEEE ( "10111110100000000000000000000000" ) // --> -.25
BinToFloat32IEEE ( "11000001000111111111111111111100" ) // --> -9.999996185302734375
BinToFloat32IEEE ( "11000011000110010011100111010010" ) // --> -153.225860595703125

IMPLEMENTATION: Requires Bin2Dec

LAST MODIFIED: 27-Jun-2018 by Arjen van Dijk

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

BinToFloat32IEEE ( binary )

Comments

Support this website.

Support this website.