decFromHex ( hexValue )

Convert a hex number into a decimal number.

Average rating: 3.5 (4 votes) Log in to vote

Arnold Kegebein
Arnold Kegebein
http://www.kegegebin.net

Sample input:

decFromHex ( "FF0033" )
decFromHex ( "FF" )

Sample output:

16711731
255

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

/*---------------------------------------------------------------------------
* decFromHex ( hexValue )
*
* PURPOSE
*	Converts a number base 16 into a regular number (base 10)
*
* PARAMETER
*	hexValue	(text) A hexadecimal number
*
* EXAMPLE
*	decFromHex( "FF0033" ) —> 16711731
---------------------------------------------------------------------------*/
Let( [
	~p = Position( "0123456789ABCDEF"; Right( hexValue; 1 ); 1; 1 )
];
	If( ~p > 0;
		~p - 1 + 16 * decFromHex( Left( hexValue; Length( hexValue ) - 1 ) )
	)
)

Optimized code.for faster conversion of hex numbers to decimal numbers.

Comments

		Bruce Robertson Oct 23, 2017
Well; OK. But there are a LOT of functions doing exactly the same thing here. What is different / better about yours?

		Arnold Kegebein, Hamburg, Germany Oct 24, 2017
The difference is speed. I tested it against some other hexâ†’dec cfs and got sometimes 80 - 100% better performance.

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

decFromHex ( hexValue )

Comments

Support this website.

Support this website.