ConvertNumber ( RC ; decimal ; NbrOfDigits ; digits )

number conversion

Average rating: 4.8 (25 votes) Log in to vote

Erich Schmidt - Show more from this author

Sample input:

ConvertNumber( "" ; 24 ; 0; "01")
Convert Number(""; 233; 0; "0123456789ABCDEF")
ConvertNumber(""; 99; 5;"01234567")

Sample output:

11000

E9

00143

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

/* Name: ConvertNumber(RC ; decimal ; NbrOfDigits ; digits)

05.06.2012 Version 1.0
==================================
Author:  Erich Schmidt, info@schmidt-it-beratung.de
==================================

The function converts a decimal number to its equivalent of any  numeral system.
The parameter "digits" determines what base is used. The number of characters in "digits" is the base. The first character in "digits" represents the figure 0. The second one represents the figure 1 and so on. 
If the parameter "NbrOfDigits" is set to 0, the function calculates the number of displayed digits itself. Otherwise  the function value contains leading zeros or is cut off.
*/  

Let(
[
digits = If( Length(digits)<2 ;"01";digits );
base = Length(digits);
NbrOfDigits = If( NbrOfDigits; NbrOfDigits; Int(1+If(decimal;Log(decimal)/Log(base);0 ) ) ) ;
RC=Middle(digits;1+Mod(decimal;base);1)&RC
]; If(NbrOfDigits-1;  ConvertNumber(RC;Int(decimal/base);NbrOfDigits-1;digits);  RC )
)

The function converts a decimal number to its equivalent of any numeral system.
The parameter "digits" determines what base is used. The number of characters in "digits" is the base. The first character in "digits" represents the figure 0. The second one represents the figure 1 and so on.
If the parameter "NbrOfDigits" is set to 0, the function calculates the number of displayed digits itself. Otherwise the function value contains leading zeros or is cut off.

Set digits to "01" to convert to binary. To convert to octal system use digits "01234567". A hexadecimal conversion makes "0123456789ABCDEF" and so on.

Comments

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

ConvertNumber ( RC ; decimal ; NbrOfDigits ; digits )

Comments

Support this website.

Support this website.