Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference SYMBOL
Functions and Expressions Reference Guide
196
SYMBOL
The SYMBOL function returns a one byte character that is the ASCII character
equivalent of a specified decimal value.
Syntax
SYMBOL ( single-integer-expression )
Meaning
SYMBOL ( decimal_value )
Returns
This function returns a single-one-byte-text-item.
The value of the resulting item is the ASCII character equivalent of
decimal_value. Valid input values are 0 to 255. Values outside of this range
return NONE.
A listing of decimal values (0-127) and their ASCII character equivalents is
included in Appendix A - Hex, Decimal, and Mercator Symbol Values.
Examples
SYMBOL ( 13 ) produces a carriage return.
SYMBOL ( 13 ) + SYMBOL ( 10 ) produces a carriage return/linefeed.
Note You can accomplish the same result using the angle-brackets around the
decimal value. For example, the second example above would be equivalent to
<CR><LF> or <<0D>><<0A>>
Uses
Use
SYMBOL to include a symbol in your output.
Related Function
HEXTEXTTOSTREAM
STREAMTOHEXTEXT