HEX_PARSE
Converts hexadecimal text into the text or data it represents
Categories: Data Parsing/Conversion
Syntax
HEX_PARSE(hex_text, [error_on_invalid_hex: FALSE])
Examples
Example 1
Input
1
{
2
"my_action": {
3
"text_hex": "546869732069732061207069656365206F662074657874"
4
}
5
}
Formula
HEX_PARSE(my_action.text_hex)
Output
"This is a piece of text"
Example 2
Input
1
{
2
"my_action": {
3
"binary_hex": "d21a261f4693f566e5bd71ebae94e5b2"
4
}
5
}
Formula
HEX_PARSE(my_action.binary_hex)
Output
"(binary data which can't be represented as text)"
Example 3
Input
1
{
2
"my_action": {
3
"text_hex": "xyz fedcba9876543210"
4
}
5
}
Formula
HEX_PARSE(my_action.text_hex, error_on_invalid_hex: TRUE)
Output
"Invalid argument to HEX_PARSE, expected hexadecimal string got xyz fedcba9876543210"