Float32toBinary ( float )

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

Average rating: 4.6 (14 votes) Log in to vote

Jake DeGroot - Show more from this author

Sample input:

Float32toBinary ( 25 )
Float32toBinary ( 1 )
Float32toBinary ( -.25 )
Float32toBinary ( 4.765 )
Float32toBinary ( -153.22586 )

Sample output:

01000001110010000000000000000000
00111111100000000000000000000000
10111110100000000000000000000000
01000000100110000111101011100001
11000011000110010011100111010010

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

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

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

EXAMPLES:

   Float32toBinary ( 25 ) // -->  "01000001110010000000000000000000"
   Float32toBinary ( 1 ) // -->  "00111111100000000000000000000000"
   Float32toBinary ( -.25 ) // -->  "10111110100000000000000000000000"
   Float32toBinary ( 4.765 ) // -->  "01000000100110000111101011100001"
   Float32toBinary ( -153.22586 ) // -->  "11000011000110010011100111010010"


IMPLEMENTATION: Requires BaseConvert (http://www.briandunning.com/cf/901) and FracDecToBin (http://www.briandunning.com/cf/1877)

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


Let(
[
dec = Position ( float ; "." ; 1 ; 1 ) ;  // Position of decimal point
f = Case( dec>1 ; float; dec = 1 ; "0." & Float; dec <1 ; float & ".0"); // If necessary add a decimal and zeros to give us numbers on both sides of the decimal
newdec = Position ( f ; "." ; 1 ; 1 );  // Position of new decimal point
whole = Left( f ; newdec-1) ; // all numbers to the left of the decimal
frac = Middle(f ; newdec+1; 9999); // all numbers to the right of the decimal
Bwhole = BaseConvert (whole;10;2); // Binary Whole
Bfrac = FracDecToBin ( frac ); // Binary Fraction
Exp = Length (Bwhole) - 1; // Calculate the Exponent
BExp = Right ( "00000000" & BaseConvert(Exp +127;10;2); 8); // Convert the exponent to 8-bit excess-127 notation
Mant = Left ( Filter ( Middle(Bwhole;2;9999) & Bfrac ; "01" ) & "00000000000000000000000" ;23); // Convert the mantissa/significand to "hidden bit" format using 23 bits
Sign = If (float<0; 1;0) // Calculate Sign bit to be 1 if the number is negative
];

/*
"dec = " & dec & ¶ & "f = " & f & ¶ & "newdec = " & newdec  & ¶ & "whole = " & whole & ¶ & "frac = " & frac & ¶ & "Bwhole = " & Bwhole & ¶ & "Bfrac = " & Bfrac & ¶ & "Exp = " & Exp & ¶ & "BExp = " & BExp & ¶ & "Mant = " & Mant  & ¶ &"Sign = " & Sign & ¶ &
"Binary = " & 
*/

Sign & BExp & Mant
)

Requires BaseConvert (http://www.briandunning.com/cf/901) and FracDecToBin (http://www.briandunning.com/cf/1877)

Comments

		Arjen van Dijk, KROHNE Altometer Jun 26, 2018
I found something strange two different inputs have the same result, where i think the second one is wrong : 1) Hex C2B60000 > Bin 11000010101101100000000000000000 > Dec -91 2) Hex C11FFFFC > Bin 11000001000111111111111111111100 > Dec -91 But must be -10 !!

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

Float32toBinary ( float )

Comments

Support this website.

Support this website.