Checksum (text)

Result Type: String

Definition: Returns a text string containing a hexadecimal representation of the 128-bit md5 hash of the given text. This is a reasonably reliable way of testing to see if there has been any change in a largish amount of data since you last checksummed it (because the checksum is small enough to store, being only 32 characters).


Checksum("some text")

returns "552e21cd4cd9918678e3c1a0df491bc3"

If you are iterating over data (detail lines of a transaction, say), you can add the previously calculated checksum by appending it to the input text (in this example, CS is a cell name inside a for loop in a report)

CS = Checksum(D.StockCode + D.StockQty + D.Gross + CS)