Data Transformation Engine Functions and Expressions Reference Guide

Contents
Functions and Expressions Reference Guide
4
Numeric Precision ......................................................................................41
Chapter 2 - Using Functions
Functions......................................................................................................42
Functions in a Component Rule ......................................................................42
Functions in a Map Rule ...............................................................................42
Syntax of a Function ........................................................................................42
Function Argument Syntax.................................................................................42
List of Functions by Category..............................................................................44
Math and Statistics Functions ........................................................................44
Bit Manipulation and Testing Functions ............................................................ 45
Date/Time Functions...................................................................................46
Conversion Functions .................................................................................. 47
Logical Functions .......................................................................................49
Text Functions ..........................................................................................49
Lookup and Reference Functions ....................................................................53
External Interface Functions .........................................................................54
Error Handling Functions .............................................................................. 55
Inspection Functions ................................................................................... 56
General Functions ......................................................................................57
Chapter 3 - Function Reference
ABS .............................................................................................................58
ABSENT ........................................................................................................60
ADDDAYS ......................................................................................................61
ADDHOURS ....................................................................................................63
ADDMINUTES..................................................................................................65
ALL .............................................................................................................66
BCDTOHEX ....................................................................................................67
BCDTOINT .....................................................................................................69
BCDTOTEXT...................................................................................................71
CHOOSE........................................................................................................73
CLONE..........................................................................................................74
CONTAINSERRORS............................................................................................75
CONVERT ......................................................................................................77
COUNT .........................................................................................................78
COUNTABS ....................................................................................................79
COUNTSTRING................................................................................................80
CURRENTDATE................................................................................................81
CURRENTDATETIME..........................................................................................83
CURRENTTIME ................................................................................................85
DATETONUMBER..............................................................................................86
DATETOTEXT..................................................................................................87
DBLOOKUP ....................................................................................................89
DBQUERY ......................................................................................................93
DDEQUERY ....................................................................................................97
DEFAULT.......................................................................................................99
ECHOIN ...................................................................................................... 100
EITHER....................................................................................................... 101
EXIT .......................................................................................................... 103
EXTRACT..................................................................................................... 107
FAIL .......................................................................................................... 108