The formula generates a hash of the specified text using the SHA256 or SHA512 algorithm. SHA256 is used by default.
| Syntax | Description |
| HASH(text) | Generates a hash of the specified text using the default SHA256 algorithm. |
| HASH(text,algorithm) | Generates a hash of the specified text using the selected SHA256 or SHA512 algorithm. |
Examples of use:
- The formula can be used when storing password hashes. Instead of storing the password itself, its hash is stored, and the hashes are compared when the password is entered. The original text cannot be directly recovered from the hash alone. However, mechanisms specifically designed for secure password storage should be used for storing passwords.
- The formula can be used when storing password hashes. Instead of storing the password itself, its hash is stored, and the hashes are compared when the password is entered. The original text cannot be directly recovered from the hash alone. However, mechanisms specifically designed for secure password storage should be used for storing passwords.
- The formula can also be used to check whether a given text in the application has been changed. To do this, compare the hash of the original text with the hash of its current version. If the hashes are different, the text has been changed.
HASH(text)
The formula generates a hash of the specified text using the default SHA256 algorithm. The original text cannot be directly recovered from the generated hash.
Syntax: hash(Text)
| Name | Description |
| Text | type: text | The text for which the hash will be generated. |
| Returns | Description |
| Text | The hash generated for the specified text |
Examples:
=hash('password')HASH(text,algorithm)
The formula generates a hash of the specified text using the selected SHA256 or SHA512 algorithm. The original text cannot be directly recovered from the generated hash.
Syntax: hash(Text,Algorithm)
| Name | Description |
| Text | type: text | The text for which the hash will be generated |
| Algorithm | type: text | optional parametr | The algorithm used to generate the hash. Available values: SHA256 or SHA512. |
| Returns | Description |
| Text | The hash generated for the specified text using the selected algorithm. |
Examples:
=hash(A3,'SHA512')
0 Comments