Brian Dunning's FileMaker Custom Functions

BaseConvert ( string ; baseFrom ; baseTo )

Convert a number (up to 10 billion) from one base to another.

  Average rating: 4.4 (40 votes) Log in to vote

Debi Fuchs   Debi Fuchs
Aptworks Consulting
http://www.aptworks.com

Share on Facebook Share on Twitter

  Sample input:
BaseConvert ( "F1"; 16; 2 )
  Sample output:
"11110001"

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

CUSTOM FUNCTION: BaseConvert ( string ; baseFrom ; baseTo )
© 2008 Debi Fuchs of Aptworks Consulting, debi@aptworks.com

Convert a number (up to 10 billion) from one base to another.

EXAMPLES:

BaseConvert( "F1"; 16; 2 ) // --> "11110001"
BaseConvert( -5; 10; 2 ) // --> "-101"
BaseConvert( 255; 10; 16 ) // --> "FF"
BaseConvert( "-101" ; 2; 10 ) // --> "-5"
BaseConvert( -101 ; 2; 10 ) // --> -5
BaseConvert( "FF"; 16; 10 ) // --> "255"
BaseConvert( "-101" ; 16; 2 ) // --> "-100000001"
BaseConvert( "-101" ; 2; 16 ) // --> "-5"
BaseConvert( "FF"; 16; 2 ) // --> "11111111"

IMPLEMENTATION: See comments. No helper functions are required. Limit is set at 10^10 so that the math does not break down, as log calculations on large numbers can be incorrect.

LAST MODIFIED: 14-AUG-2008 by Debi Fuchs of Aptworks Consulting

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.