Dec2HexNoLeading0s ( theNumber )

Convert Decimal # to Hex Text with no leading zeros

Average rating: 3.9 (33 votes) Log in to vote

Samuel Herschbein - Show more from this author
Comsultant
http://www.oz.net/~samh

Sample input:

Dec2HexNoLeading0s ( 35243 )

Sample output:

89AB

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

Let (

  // get the hex digit for the least significant nibble (4 bits)
   thisNibble = Middle ( "0123456789ABCDEF" ; Mod (theNumber ; 16) + 1 ; 1 ) ;

  // see if theNumber passed is bigger than a nibble, if so recurse to process the more significant nibbles
  If ( theNumber < 16 ;
    "" ;  // blank means we're not adding any extra
    Dec2HexNoLeading0s ( Int ( theNumber / 16 ) ) // add the more significant nibbles
  ) &
  thisNibble // always return the least significant nibble

)

This function can stand alone, it returns as many digits as required to express the # in hex. My other function, Dec2Hex, specifies how many leading zeros (more useful to see RGB colors in web format.

Comments

		John Dec 4, 2009
What are the function parameters for this script? When I paste the script into the "Custom Function Window" it says to specify function paramenters.

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

Dec2HexNoLeading0s ( theNumber )

Comments

Support this website.

Support this website.