ConvertFromBase ( str ; base ; charSet )

Convert any base to decimal

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

Steven R. Allen
Richard Carlton Consulting, Inc.
http://www.rcconsulting.com

Sample input:

Ex.1: ConvertFromBase ( 420 ; 7 ; "0123456" )

Ex. 2: ConvertFromBase ( "114E2" ; 18 ; "0123456789ABCDEFGH" )

Sample output:

Ex. 1: 210

Ex. 2: 112358

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

/*
 * Created: 2014-01-16
 * By: Steven R. Allen, Richard Carlton Consulting, Inc.
 * Version: 1.0
 * 
 * Purpose: Conversion of representation of a number any base and any character set to decimal with Arabic numeral representation.
 * 
 * Notes:
 *       - There is one restriction that I can think of: each value that could go in any particular place has to be represented by a single character; what character is used for what value is completely arbitrary, however.
 *
 *      - Also, there is an assumption that the character set is coded to values starting at zero on the left, and rising by +1 as it proceeds to the right, like we are used to reading the arabic numeral sequence 0123456789, etc.
 */

Case ( not IsEmpty ( str ) ;

Let ([
	power = Length ( str ) - 1
;	place = base ^ power
;	character = Left ( str ; 1 )
;	value =  Position ( charSet ; character ; 1 ; 1  ) - 1
];	

( value * place ) + Case ( power ; ConvertFromBase ( Right ( str ; Length ( str ) - 1 ) ; base ; charSet ) )

) ; 0 )

This function converts any string representation of a number in any base to decimal (conventionally represented), so long as the specified base's value-to-character mapping is supplied.

Comments

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

ConvertFromBase ( str ; base ; charSet )

Comments

Support this website.

Support this website.