r_md5sum(C;S)

Returns the MD5 hash of data across a given set of columns.

Function type

Vector only

Syntax

r_md5sum(C;S)

Input

Argument Type Description
C any A space- or comma-separated list of column names

C may also be a string expression (in single quotes) constituting a pattern for matching columns. For instance, 'foo*' specifies all columns that begin with "foo".

If C is omitted, the values in all of the columns are included.

S integer A boolean column or an expression in rcv_/rcn_/rct_ which determines whether or not that column is selected to be included in the calculation. See System variables for more information about rcv_/rcn_/rct_.

If S is omitted, all columns will be considered by the function (subject to any prior column selections).

Return Value

For each row of the table, r_md5sum returns a text value representing the 32-digit hexadecimal number that corresponds to the MD5 hash (checksum) of the values in the columns specified by C.

Sample Usage

c1 c2 c3 c4 r_md5sum(;) r_md5sum(c1 c2;)
2 5 7 2 f7b45cb967082666461b6e14687ce7ab 11f001789301a4c7a73054491ea608ef
7 7 4 1 3ab5875d55c0d75e778866979be4d178 d3f9e81adfce95fd40dc8ada3b8b8a3a
NA 0 9 3 9f7d520c1d3d58a525972681039f3b22 a8d367e604b13a3e77e34a77ad49c572
NA NA NA NA df3abb567fd6267b4e3900ad939d0ae5 98dcdc66177e7fdb1bcc21facfb7da8c