Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference TEXT
Functions and Expressions Reference Guide
200
TEXT
The TEXT function converts the content of a group or item object to a text item.
Syntax
TEXT ( single-object-expression )
Meaning
TEXT ( object_to_convert )
Returns
This function returns a single-text-item.
Converts object_to_convert to a text-item, excluding the initiator and
terminator of the input object.
Examples
In this example, the group Record has an initiator of the pound sign #, a
terminator of the at-sign @, and a delimiter of a comma ,.
The example’s data looks like this:
#1339X10A,491.38,Green,42x54@
TEXT ( Record:card ) returns 1339X10A,491.38,Green,42x54
The initiator and terminator are not included because only the content of the
object is converted to text.
Uses
Use
TEXT to convert an object to a text item. Use TEXT when echoing entire
data objects to another map.
TEXT differs from PACKAGE in that it does not include the initiator and
terminator of the input object.
Related Functions
DATETOTEXT, FROMDATETIME, FROMNUMBER, NUMBERTOTEXT, PACKAGE,
SERIESTOTEXT, TIMETOTEXT