Data Transformation Engine Functions and Expressions Reference Guide

Index P
Functions and Expressions Reference Guide
257
in expressions, 28
logical, 29
order of evaluation, 30
text, 28
OR function, 160
output items
conversion of, 39
P
PACK function, 161
PACKAGE function, 162
PARTITION function, 163
partitions
in an expression, 14
PRESENT function, 164
PROPERCASE function, 165
PUT function, 166
R
REFORMAT function, 168
REJECT function, 170
related references, 8
reserved words and symbols
" ", 231
$, 20, 231
(), 231
:, 16, 231
:.:, 21, 231
@, 19, 231
[ ], 15, 231
{}, 231
< >, 14, 231
<comma>, 231
<space>, 233
ANY, 232
COMPONENT, 232
COMPONENTS, 13
FALSE, 232
IN, 12, 232
LAST, 15, 232
NONE, 232
TRUE, 233
WHERE, 233
REVERSEBYTE function, 171
RIGHT function, 172
ROUND function, 173
RUN function, 174, 251
S
SEARCHDOWN function, 176
SEARCHUP function, 178
SERIESTOTEXT function, 180
SETOFF function, 182
SETON function, 184
shorthand notation, 19
in a map rule, 21
SIZE function, 186
SORTDOWN function, 187
SORTUP function, 189
SQRT function, 190
SQUEEZE function, 191
STREAMTOHEXTEXT function, 192
SUBSTITUTE function, 194
SUM function, 195
SYMBOL function, 196
T
TESTOFF function, 197
TESTON function, 198
text
as a literal, 10
concatenating, 28
operators, 28
TEXT function, 200
TEXTTOBCD function, 201
TEXTTODATE function, 203
TEXTTONUMBER function, 204
TEXTTOTIME function, 205
TIMETOTEXT function, 206
TOBASETEN function, 207
TODATETIME function, 208
TONUMBER function, 209
TRIMLEFT function, 212
TRIMRIGHT function, 213
TRUE, reserved word, 233
TRUNCATE function, 214
type names
local, 14
U
UNIQUE function, 215
UNPACK function, 216
UNZONE function, 217
UPPERCASE function, 219
V
VALID function, 220
W
WHEN function, 221
WHERE, reserved word, 233
WORD function, 223
Z
ZONE function, 225