FileMaker Pro Custom Functions

// Bin2hex ( binary ) // Converts a binary number to hexadecimal // // Written by Vaughan Bromfield // vbromfield@optusnet.com.au // 14 March 2010 Let( [ bits = 4 ; byte = Right( "0000" & Right( binary ; bits ) ; bits ) ; nextbinary = If( Length( binary ) ≥ bits ; Left( binary ; Length( binary ) - bits ) ; binary ) ; num = Middle( byte ; 4 ; 1 ) * 2^0 + Middle( byte ; 3 ; 1 ) * 2^1 + Middle( byte ; 2 ; 1 ) * 2^2 + Middle( byte ; 1 ; 1 ) * 2^3 ; digit = Choose( num ; "0" ; "1" ; "2" ; "3" ; "4" ; "5" ; "6" ; "7" ; "8" ; "9" ; "a" ; "b" ; "c" ; "d" ; "e" ; "f" ; "g" ) ] ; Case( Length( binary ) ≤ bits ; digit ; // exit the recursion Bin2hex ( nextbinary ) & digit // more to process ) // end case ) // end let
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.