Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference UNZONE
Functions and Expressions Reference Guide
218
Zoned integers have a series of digits except for the rightmost byte. The
rightmost byte is a digit with a super-imposed sign. See ZONE for a list of
rightmost byte values.
Examples
UNZONE ( "123D" ) returns 1234
UNZONE ( "1234" ) returns 1234
UNZONE ( TaxRate ) / 1000 * Income
TaxRate is converted from zoned format to a signed decimal and divided by
1000 (to convert it to a number with three decimal places), and then multiplied
by Income.
Uses
Use
UNZONE to convert a text item that represents a zoned (signed) number to
an integer.
Note You can define items as having a zoned character number presentation. Then,
when mapping to or from these items, the conversion to and from zoned
decimal is automatically performed, as needed.
Related Function
ZONE