Description
Perform one-way hashing on selected columns.
Example
Compute the MD5 hash of <'Hello World!'>:
Type |
Plaintext |
Secret |
Hashed |
|---|---|---|---|
SHA1 |
<'Hello World!'> |
|
4a700d8555aae497cc54d32f6f3d7478200a5dea |
SHA-256 |
<'Hello World!'> |
|
2c6139a5d874b9626e3ae2443fa85cdfe1fc18f1480348267f8bf71a783f738a |
SHA-512 |
<'Hello World!'> |
|
23728b865af0f17bb9bfaaf064f711bf00626c07e5389dcbb18365ace19c2394d7a00066c0b6a7112dab528e62106a855dd6bc41d0c262fb72e9f47e10f1652c |
SHA3-256 |
<'Hello World!'> |
|
0701263723cdbdf11e1f7118e62d7d29d61f01f8490ef775e4991558634bd719 |
SHA3-512 |
<'Hello World!'> |
|
61cbf6f11e864af592626d9430271a5ad6f39edf7e09719a97c57b5c3222cdf24bd70f1f6927b7b41eb948bbddfe0a4ae965688a4a6882df7be36492ad653ab0 |
Keccak-256 |
<'Hello World!'> |
|
1a45dd8df9de65049692d9192509b30560b69c1fd881c57b2cf4607e85b3569f |
Keccak-512 |
<'Hello World!'> |
|
2741b7ddfe0d4c4726d476cc719fdbb3b7db88fe6df1a1df00723547c546496ac49bd82e94009f4572d3a31fe0fc50bce1ee3c76d983f8ddc480b7da9cd1ed02 |
MD5 |
<'Hello World!'> |
|
f0d946347af462d489af835d3737fe70 |
HMAC-MD5 |
<'Hello World!'> |
ABC123 |
5940ca9b5f2b47ae1972ab81db8030ac |
HMAC-MD5 |
<'Hello World!'> |
abc123 |
b185f719143d6380ccabe07d5d2743eb |
Inputs
One.
Options
•Check the column(s) you wish to transform.
•Set Algorithm to the hashing algorithm you wish to use
•Set Secret to the secret key you wish to use (HMAC-MD5 only). The default value is randomly generated.
Notes
•There is no known way to reverse these hashes.
•As the chance of 2 different inputs generating the same hash value by chance (a 'collision') is infinitesimally small, hashing can be used to anonymize data or to help find duplicates of long data values.
•The MD5 algorithm is now considered weak as a cryptographic hash. But remains suitable for other non-cryptographic purposes.
•Use Copy Cols to copy columns before you transform them.