Hash

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Hash

Description

Perform one-way hashing on selected columns.

 

Example

Compute the MD5 hash of <'Hello World!'>:

 

MD5 hashing example

 

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.