Syntax
HEX_PARSE(hex_text, [error_on_invalid_hex: FALSE])Usage 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" |