Returns either container or text content from text encoded in hexadecimal format.
HexDecode ( data {; fileNameWithExtension } )data - text expression or text field that contains hexadecimal data to decode.
fileNameWithExtension - text expression or text field that contains the filename and extension to use when the returned content is stored in a container field.
text, container
FileMaker Pro 16.0
To decode a hexadecimal value and return the result in a text field (or a variable used as text data), for the data parameter, specify text that was in UTF-8 format and then hex encoded.
To decode a hexadecimal value that represents binary data, return the result in a container field (or a variable used as container data) and specify the fileNameWithExtension parameter. If a filename and extension are not specified, this function returns text rather than container data.
•This function is not supported in runtime solutions and returns "?".
HexDecode ( "46696C654D616B6572" ) returns FileMaker.
Decodes hexadecimal data in a text field and stores it as a file named key.data in a container field.
Set Field [ table::container ; HexDecode ( table::text ; "key.data" ) ]