BytesToDec ( hex )

Converts MSB->LSB hexadecimal bytes to decimal

Average rating: 5.0 (2 votes) Log in to vote

Richard Dyce - Show more from this author
Dyce & Sons Ltd.
http://dyce.com

Sample input:

BytesToDec ( "10AB" )

Sample output:

4267

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

// BytesToDec ( hex )
// Converts MSB->LSB hexadecimal bytes to decimal
//
// BytesToDec ( "1000" ) => 4096
// BytesToDec ( "ab" )   => 171
// BytesToDec ( "a" )    => ? error
// BytesToDec ( "0a" )   => 10
Let (
	[
		h = Upper( hex );
		l = Length ( h );
		c2 = Left( h ; 1 ) ;
		c1 = Middle ( h ; 2 ; 1);
		v = 16 * Substitute( c2 ; ["A";10]; ["B";11]; ["C";12]; ["D";13]; ["E";14]; ["F";15] ) +  
			Substitute( c1 ; ["A";10]; ["B";11]; ["C";12]; ["D";13]; ["E";14]; ["F";15] )
	];

	Case(
		Mod( l ; 2 ) ≠ 0 ; Evaluate("Factorial(-1)");
		Filter ( h ; "0123456789ABCDEF" ) ≠ h ; Evaluate("Factorial(-1)");
		l = 2 ; v ;
		16 ^ ( l - 2 ) * v + BytesToDec( Middle ( h ; 3 ; Length( h ) ) )
	)
)

Handles upper and lower cased hex bytes, i.e. digit pairs.
Non-even-length strings are rejected.

Comments

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

BytesToDec ( hex )

Comments

Support this website.

Support this website.