FileMaker Pro Custom Functions

// HashFNV1a32 ( text ; empty ) // The initial value for "empty" must be empty ("") // // This function computes the 32-bit binary hash // for the input text based on the FNV-1a algorithm // // This function requires the following functions: // Bin2dec ( bin ; empty ) // Dec2bin ( decimalNumber ; empty ) // XORbin ( bin0 ; bin1 ; empty ) // // This custom function was written by Vaughan Bromfield // vbromfield@optusnet.com.au // 14 March 2010 // // This function is based on the algorithm published at: // http://www.isthe.com/chongo/tech/comp/fnv/index.html // http://en.wikipedia.org/wiki/Fowler_Noll_Vo_hash Case ( Length( text ) = 0 ; empty ; // return 32 bit binary result Let( [ offset = 2166136261 ; prime = 16777619 ; chr = Right ( text ; 1 ) ; nextxt = Left ( text ; Length( text ) - 1 ) ; hash0 = If( IsEmpty( empty ) ; Dec2bin( offset ; "" ) ; empty ) ; hash1 = XORbin( hash0 ; Dec2bin( Code( chr ) ; "" ) ; "" ) ; hash2 = Right( "00000000000000000000000000000000" & Dec2bin( Mod( Bin2dec( hash1 ; "" ) * prime ; 2^32 ) ; "" ) ; 32 ) ] ; HashFNV1a32 ( nextxt ; hash2 ) ) //end let ) //end case
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.