Data Transformation Engine Functions and Expressions Reference Guide

Contents
Functions and Expressions Reference Guide
5
FILLLEFT..................................................................................................... 110
FILLRIGHT ................................................................................................... 111
FIND.......................................................................................................... 112
FROMBASETEN.............................................................................................. 114
FROMDATETIME............................................................................................. 115
FROMNUMBER............................................................................................... 116
GET........................................................................................................... 117
GETANDSET ................................................................................................. 119
GETDIRECTORY............................................................................................. 121
GETFILENAME............................................................................................... 123
GETPARTITIONNAME....................................................................................... 125
GETRESOURCENAME....................................................................................... 126
HEXTEXTTOSTREAM ....................................................................................... 127
IF.............................................................................................................. 129
INDEX ........................................................................................................ 130
INDEXABS.................................................................................................... 132
INT............................................................................................................ 134
ISALPHA...................................................................................................... 135
ISERROR ..................................................................................................... 136
ISLOWER..................................................................................................... 138
ISNUMBER ................................................................................................... 139
ISUPPER...................................................................................................... 140
LASTERRORCODE........................................................................................... 141
LASTERRORMSG ............................................................................................ 143
LEAVEALPHA ................................................................................................ 145
LEAVEALPHANUM .......................................................................................... 146
LEAVENUM................................................................................................... 147
LEAVEPRINT................................................................................................. 148
LEFT.......................................................................................................... 149
LOOKUP...................................................................................................... 150
LOWERCASE................................................................................................. 152
MAX........................................................................................................... 153
MEMBER...................................................................................................... 154
MID ........................................................................................................... 155
MIN ........................................................................................................... 156
MOD .......................................................................................................... 157
NOT .......................................................................................................... 158
NUMBERTODATE............................................................................................ 159
NUMBERTOTEXT............................................................................................ 160
OFFSET....................................................................................................... 161
ONERROR.................................................................................................... 162
OR ............................................................................................................ 164
PACK ......................................................................................................... 165
PACKAGE .................................................................................................... 166
PARTITION................................................................................................... 167
PRESENT..................................................................................................... 168
PROPERCASE................................................................................................ 169
PUT........................................................................................................... 170
REFORMAT .................................................................................................. 171
REJECT....................................................................................................... 171
REVERSEBYTE............................................................................................... 171
RIGHT ........................................................................................................ 171