BinToFloat32 ( binary )

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

Average rating: 4.1 (20 votes) Log in to vote

Jake DeGroot - Show more from this author

Sample input:

BinToFloat32 ( "01000001110010000000000000000000" )
BinToFloat32 ( "00111111100000000000000000000000" )
BinToFloat32 ( "10111110100000000000000000000000" )
BinToFloat32 ( "01000000100110000111101011100001" )
BinToFloat32 ( "11000011000110010011100111010010" )

Sample output:

25
1
-.25
4.675
-153.22586

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

/*
CUSTOM FUNCTION: BinToFloat32 ( binary )
© 2016 Jake DeGroot, jakedeg@gmail.com

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

EXAMPLES:

   BinToFloat32 ( "01000001110010000000000000000000" ) // -->  25
   BinToFloat32 ( "00111111100000000000000000000000" ) // -->  1
   BinToFloat32 ( "10111110100000000000000000000000" ) // -->  -.25
   BinToFloat32 ( "01000000100110000111101011100001" ) // -->  4.675
   BinToFloat32 ( "11000011000110010011100111010010" ) // -->  -153.22586


IMPLEMENTATION: Requires BaseConvert (http://www.briandunning.com/cf/901) and BinToFracDec (http://www.briandunning.com/cf/1878)

LAST MODIFIED: 29-MARCH-2016 by Jake DeGroot
*/


Let(
[
b = Right( "00000000000000000000000000000000" & GetAsText(binary);32);
sign = If ( Left (b;1) ; -1 ; 1 ); //Find Sign
Bexp = Middle (b; 2;8);  //Find exponent
Exp = BaseConvert (Bexp;2;10)-127; // Exponent as base 10
BMant = "1."& GetAsText(Middle (b; 10;23)); // Find Mantissa
Bin = GetAsText(BMant * 10^Exp);
P = Position ( Bin ; "." ; 1 ; 1 );
l = If ( p ; GetAsText(Left (Bin;p-1)) ; GetAsText(Bin)); // Left of decimal if there is one, or else the whole thing.
r = If ( p ; Middle ( Bin; p+1;16)); //Right of decimal if there is one, or else nothing.
dec = sign* BaseConvert(l;2;10) & If( r; BinToFracDec ( r ))
];

 
"b = " & b & ¶ & "sign = " & Sign & ¶ & "Bexp = " & Bexp & ¶ & "Exp = " & Exp & ¶ & "BMant = "& BMant & ¶ & "Bin = " & bin & ¶ & "l = " & l & ¶ & "r = " & r & ¶ &  
 

dec 
)

Requires BaseConvert (http://www.briandunning.com/cf/901) and BinToFracDec (http://www.briandunning.com/cf/1878)

Comments

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

BinToFloat32 ( binary )

Comments

Support this website.

Support this website.