Data Transformation Engine What's New Reference Guide

Chapter 7 – Version 6.0 Mercator Design Studio Enhancements
What's New Reference Guide
36
EITHER (B, DEFAULT(B))
Returns the value for B when B exists and has content. Otherwise, returns
MyDefault.
New: ECHOIN
A new function, ECHOIN, has been added to make the RUN function easier.
Syntax
ECHOIN (
single-number-expression , single-text-expression )
Meaning
ECHOIN (
card# , input-echo-source-command )
Returns a text item whose value is a Mercator input echo source override
command to be used in a
RUN function argument.
For example,
RUN (“MyMap”, ECHOIN(1,Data))
replaces the current method:
" -IE1S" + NUMBERTOTEXT (SIZE (DATA)) + " " + TEXT (DATA)
New: REFORMAT
The REFORMAT function returns a type object that results from replacing the
syntax of the input type with the syntax of the output type. The initiator and
terminator of the output type are built. The content result rules are determined
based on the Input type and the Output type. Groups and Items can be used with
REFORMAT.
REFORMAT cannot be used as an argument to a function, operator, or functional
map.
Syntax
REFORMAT ( single-object-expression )
Meaning
REFORMAT (
type-to-convert )