BinToFracDec ( bin )

Convert a binary fraction to a fractional decimal.

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

Jake DeGroot

Sample input:

FracDecToBin ( ".101" )
FracDecToBin ( ".000110011001100" )

Sample output:

.625
.1

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

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

Convert a binary fraction to a fractional decimal. 

EXAMPLES:

   FracDecToBin ( ".101" ) // -->  .625
   FracDecToBin ( ".000110011001100" ) // -->  .1


IMPLEMENTATION: Requires BaseConvert: http://www.briandunning.com/cf/901

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



Let([
b = GetAsText(bin);
p = Position ( b ; "." ; 1 ; 1 ); //Find the decimal
x = If ( p ; b ; "."& b ); //Add a leading decimal if there isn't one.
m = x*10^20;
dec = BaseConvert(m;2;10);
y = dec/(2^20);
l = Length(y)
];
If (l>15; Round(y;4);y)
)

Requires BaseConvert: http://www.briandunning.com/cf/901

Comments

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