Data Transformation Engine Functions and Expressions Reference Guide

Chapter 1 - Expressions and Evaluations Literals
Functions and Expressions Reference Guide
10
Map Rule Expressions Evaluate to Data
Map rules are expressions that evaluate to data.
For example, the result of each of the following map rules is data:
= "Florida"
= Price:Input
= COUNT ( Name:Roster )
= RecordMap ( FixedRecord )
Literals
A literal is a constant value. A literal may be a number or a text string.
The rules for using numeric literals are:
♦ A numeric literal is in integer or decimal format and can be signed.
♦ A comma separator should not be included in a numeric literal.
♦ A numeric literal cannot be greater than 254 digits.
The rules for using text literals are:
♦ A text literal is enclosed in double quotes.
♦ A double-quote included in a text literal is released by another double quote.
The following are some examples of literals:
"This is a text literal"
"ABC Company"
"Some ""quoted data"" to show use of a double double-quote."
1.23
-9
1045
Carriage return/line feeds cannot be within a quoted string. To use a carriage
return/line feed the string must be broken into two strings with <CR><LF>
between them. For example:
="username=?????" + "<CR><LF>" + "&password=?????"
will place the output username and password information on separate lines.
Note <CR><LF> must be within quotation marks.