Data Transformation Engine Functions and Expressions Reference Guide

Index F
Functions and Expressions Reference Guide
256
shorthand notation in, 19
EXTRACT function, 104
F
FAIL function, 105
FALSE reserved word, 232
FILLLEFT function, 107
FILLRIGHT function, 108
FIND function, 109
floating component type
in an expression, 19
FROMBASETEN function, 111
FROMDATETIME function, 112
FROMNUMBER function, 113
Function
used to convert output item value, 39
functional maps
evaluation of, 35
name in an expression, 34
functions
arguments, 31
evaluation of, 31
G
GET function, 114
GETANDSET function, 116
GETDIRECTORY function, 118
GETFILENAME function, 120
GETPARTITIONNAME function, 122
GETRESOURCENAME function, 123
H
hex values, 234
HEXTEXTTOSTREAM function, 124
I
IF function, 126
IN
in component path, 16
reserved word, 12, 27, 232
INDEX function, 127
INDEXABS function, 129
indexing
an input, 15
input
indexing, 15
inspection functions, 56
INT function, 131
ISALPHA function, 132
ISERROR function, 133
ISLOWER function, 134
ISNUMBER function, 135
ISUPPER function, 136
L
LAST reserved word, 15, 232
LASTERRORCODE function, 137
LASTERRORMSG function, 139
LEAVEALPHA function, 141
LEAVEALPHANUM function, 142
LEAVENUM function, 143
LEAVEPRINT function, 144
LEFT function, 145
literals
definition of, 10
in expressions, 10
local type name, 14
logical operators, 29
LOOKUP function, 146
LOWERCASE function, 148
M
map names in an expression, 34
map rules
evaluation, 10
MAX function, 149
MEMBER function, 150
MID function, 151
MIN function, 152
MOD function, 153
N
names
data object, 11
in a component rule, 13
in a map rule, 12
NONE reserved word, 36, 232
assigned to an output number, 39
when an input argument of a function evaluates
to, 37
when an input argument of a functional map
evaluates to, 37
when an operand evaluates to, 36
NOT function, 154
numbers
as literal, 10
NUMBERTODATE function, 155
NUMBERTOTEXT function, 156
O
object names, 11
OFFSET function, 157
ONERROR function, 158
operands
evaluation of, 31
operators
arithmetic, 28
comparison, 29