Magic Required:Create unique field HASH(MD5) or equivalent.

billy_bragg · Post by **billy_bragg** » Sun Sep 30, 2007 3:35 am

I am interested in creating a "unique key" based on several strings using a HASH thingy .

I have a database challenge where I would like to compare records from two databases (.CSV files actually) using three variables CODE, LABEL and COUNT (for example). What I hope macro scheduler will do is read in the three columns... do some magic and write a unique key calculated using HASH (MD5?)... and presto. I anticipate that a smaller, unique key will speed up the matching process.

I am ok with the file reading in part and the writing file part... it is the calculation part I am looking for. Any help to this challenge would be appreciated.

Post by **Marcus Tettmar** » Sun Sep 30, 2007 7:46 am

Download the MD5/SHA hash library:
http://www.mjtnet.com/plugins.htm

billy_bragg · Post by **billy_bragg** » Mon Oct 01, 2007 2:08 am

Wow, this software continues to be an outstanding investment.