BaseX_ToDecimal ( baseString ; decimalNumber )

Convert a some base to decimal number.

Average rating: 3.7 (3 votes) Log in to vote

Erik Shagdar - Show more from this author
NYHTC

Sample input:

BaseX_ToDecimal ( "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; "HELLO" )

Sample output:

29234652

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

// BaseX_ToDecimal ( baseString; decimalNumber )
// version 1.0, Erik Shagdar, NYHTC

/*
	Convert a some base to decimal number.


NOTE:
	Recursive


HISTORY:
	1.2 - 2017-06-20 ( eshagdar ): first created.
*/


Let ( [
		lastChar = Right ( baseNum; 1 );
		posChar = Position ( baseString; lastChar; 1; 1 ) - 1;
		remainingStr = Left ( baseNum; Length ( baseNum ) - 1 )
	];

	posChar + Length ( baseString ) * If ( not IsEmpty ( remainingStr ); BaseX_ToDecimal ( baseString; remainingStr ); 0 )
)

Once a number is convert from decimal to some other base, this function can convert it back.

Comments

		Tazz Richards, San Francisco Apr 17, 2018
I could only get this to return a 0 or -1.

		Erik, NYC Apr 18, 2018
Hey Tazz, what were the params you used?

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

BaseX_ToDecimal ( baseString ; decimalNumber )

Comments

Support this website.

Support this website.