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
If |
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
|
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 |