IBM® Macros Reference
This section provides reference information for the available spreadsheet macro functions in the IBM® Marketing Platform suite.
The available macros are listed on the following pages, in alphabetical order. Each macro is provided with its syntax, possible parameters, and some examples.
*
Do not use function names or keywords from the IBM® Macro Language for column headings on user tables in IBM® Campaign, whether mapping from a database or a flat file. These reserved words can cause errors if used in column headings on mapped tables.
Valid Format Keywords
ABS macro
ACOS macro
ACOT macro
ADD_MONTHS macro
AND macro
ASIN macro
ATAN macro
AVG macro
BETWEEN macro
BIT_AND macro
BIT_NOT macro
BIT_OR macro
BIT_XOR macro
CEILING macro
COLUMN macro
COS macro
COSH macro
COT macro
COUNT macro
CURRENT_DATE macro
CURRENT_DAY macro
CURRENT_JULIAN macro
CURRENT_MONTH macro
CURRENT_TIME macro
CURRENT_WEEKDAY macro
CURRENT_YEAR macro
DATE macro
DATE_FORMAT macro
DATE_JULIAN macro
DATE_STRING macro
DAY_BETWEEN macro
DAY_FROMNOW macro
DAY_INTERVAL macro
DAYOF macro
DISTANCE macro
DIV macro
EQ macro
EXP macro
Utilizzo EXTERNALCALLOUT
FACTORIAL macro
FLOOR macro
FORMAT macro
FRACTION macro
GE macro
GROUPBY macro
GROUPBY_WHERE macro
GT macro
IF macro
IN macro
INT macro
INVERSE macro
IS macro
ISERROR macro
ISODD macro
ISODD macro
ISEVEN macro
LE macro
LIKE macro
LN or LOG macro
LOG2 macro
LOG10 macro
LOWER macro
LT macro
LTRIM macro
MAX macro
MEAN macro
MIN macro
MINUS macro
MOD macro
MONTHOF macro
MULT macro
NE macro
NOT macro
NUMBER macro
OR macro
POSITION macro
PLUS macro
POW macro
RANDOM macro
RANDOM_GAUSS macro
ROUND macro
ROWNUM macro
RTRIM macro
SIGN macro
SIN macro
SINH macro
SQRT macro
STDV or STDEV macro
STRING_CONCAT macro
STRING_HEAD macro
STRING_LENGTH macro
STRING_PROPER macro
STRING_SEG macro
STRING_TAIL macro
SUBSTR or SUBSTRING macro
SUM macro
TAN macro
TANH macro
TOTAL macro
TRUNCATE macro
UPPER macro
VARIANCE macro
WEEKDAY macro
WEEKDAYOF macro
XOR macro
YEAROF macro
Copyright IBM Corporation 2015. All Rights Reserved.