Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference HEXTEXTTOSTREAM
Functions and Expressions Reference Guide
124
HEXTEXTTOSTREAM
The HEXTEXTTOSTREAM function returns a binary text stream whose value is the
evaluation of input character text represented by hex pairs.
The
HEXTEXTTOSTREAM function is the reverse of the STREAMTOHEXTEXT function.
Input Formats
The following table shows an example of input in its character text representation
as viewed through the character editor, and in its ASCII code representation
(binary text stream) as viewed through the hex editor. Each pair of binary text in
the hex view represents one character in the character view of the character text.
Input (“41 42 43 44”) Editor View Value
Character text (hex pairs) Character “41 42 43 44”
ASCII code representation
(binary text stream)
Hex 0x3431203432203433203434
Syntax
HEXTEXTTOSTREAM (single-text-expression)
Meaning
HEXTEXTTOSTREAM (series_of_hex_pairs)
Returns
This function returns a single-byte-stream-item.
Returns a binary text stream item whose value is the evaluation of input
character text in series_of_hex_pairs, ignoring <WSP> characters between the
hex-pairs. White space characters include space, horizontal tab, carriage
return, and line feed characters.
Examples
HEXTEXTTOSTREAM ("41 42 43 44")
Returns the evaluated value of the input (ASCII) character text string “41 42
43 44” as the output (ASCII) character text string “ABCD” as viewed in the