You are here: Functions

Functions

Analyzer functions are divided into eight categories to help you identify their purpose. When you are working in the Expression Builder, you can View the functions in the Functions drop-down list. To View all the functions, select All from the list. To View a subset of the functions, select a category from the list.

Summary of Functions

ABSOLUTE()

ACOSINE()

AGE()

ALLTRIM()

ARRANGE()

ASCII()

ASINE()

AT()

ATANGENT()

AVERAGE()

BETWEEN()

BIT()

BLANKS()

BYTE()

CDOW()

CHR()

CLEAN()

CMON()

COMPACT()

COSINE()

CTOD()

DATE()

DAY()

DECIMALS()

DIFFERENCE()

DIGIT()

DOW()

EBCDIC()

EFFECTIVE()

EOMONTH()

EXCLUDE()

EXPONENT()

FILEDATE()

FILESIZE()

FIND()

FORMAT()

FREQUENCY()

FTYPE()

FVANNUITY()

FVLUMPSUM()

GOMONTH()

HEXADECIMAL()

HOUR()

INCLUDE()

INSERT()

INTEGER()

ISBLANK()

ISDEFINED()

LAST()

LEADING()

LEFT()

LENGTH()

LFILL()

LISTFIND()

LOGARITHM()

LOWER()

LTRIM()

MAP()

MASK()

MATCH()

MAXIMUM()

MINIMUM()

MINUTE()

MOD()

MONTH()

NEAR()

NOMINAL()

NORMALIZE()

NOW()

NPER()

NTOD()

NTOT()

OCCURS()

OFFSET()

PACKED()

PMT()

PROPER()

PVANNUITY()

PVLUMPSUM()

RADIANS()

RANDOM()

RATE()

RECLEN()

RECNO()

RECOFFSET()

Regular Expressions

REGEXFIND()

REGEXREPLACE()

REMOVE()

REPEAT()

REPLACE()

REVERSE()

RIGHT()

RJUSTIFY()

ROOT()

ROUND()

SECOND()

SHIFT()

SIMILAR()

SINE()

SMARTSEARCH()

SORTNORMALIZE()

SOUNDEX()

SOUNDSLIKE()

SPLIT()

STRING()

SUBSTRING()

TANGENT()

TEST()

TIME()

TODAY()

TOTAL()

TRANSFORM()

TRIM()

UNICODE()

UNSIGNED()

UPPER()

VALUE()

VERIFY()

WEEKEND()

WORKDAY()

YEAR()

ZONED()

ZSTAT()