You are here: Analyzer Concepts > Additional Operations and Routines > Functions

Functions Overview

Analyzer functions are sophisticated analytical routines that allow you to manipulate data and perform a wide range of computational tasks. They are mainly used to create computed fields or tests for filtering records. Character string functions let you edit character data, making them useful for normalizing data in key fields.

Analyzer has many functions not found in other programs, though most functions available in spreadsheet and database programs are also available in Analyzer. You can use functions individually or in combination.

Analyzer has nine categories of functions:

Financial
Mathematical
Character String
Data Conversion
Date and Time
Bit/Character
Logical
Fuzzy Search
Miscellaneous