Hash Strings

Computes cryptographic hashes for a String column.
Simply speaking, it generates unique fingerprints for String contents.
It is practically impossible to find 2 different input values sharing the same hash value (collision resistence). Besides brute force attempts of trying many inputs, it is also practically impossible to restore the original content from the fingerprint (oneway function).

Options

Input column
String column to be hashed.
Hash Function
The cryptographic hash function to use.
Output Format
The choice of output format. For example, the String "abc" with character set UTF8, will SHA-256 hash to:%%00010* hex (upper case): BA7816BF8F01CFEA414140DE5DAE2223B00361A396177A9CB410FF61F20015AD%%00010%%00010* hex (lower case): ba7816bf8f01cfea414140de5dae2223b00361a396177a9cb410ff61f20015ad%%00010%%00010* base64 (with padding): ungWv48Bz+pBQUDeXa4iI7ADYaOWF3qctBD/YfIAFa0=%%00010%%00010* base64 (without padding): ungWv48Bz+pBQUDeXa4iI7ADYaOWF3qctBD/YfIAFa0
Input charset
The character set to be used for the input String. Use UTF-8 if unsure.
Output column name
The name of the output column holding the hashed values.

Input Ports

Icon
Table containing a String column to hash.

Output Ports

Icon
The input table enriched by the selected output column holding the hash values.

Nodes

Extensions

Links