Expression Builder Functions

Three types of functions (String, Date, and Data Privacy) are included as part of the Data Privacy program. In addition, you can create custom functions that will become available on the Functions tab (after they are created and stored on the execution server where the engine is located).

All string functions refer to characters, not bytes. International characters are supported, including both single-byte and double-byte characters.

For all functions, if a NULL source value is passed to the function, the string returned will also be NULL.

Each function validates the parameters passed to it and if invalid parameters are passed to a function, the function terminates with an appropriate message and return code.

String Functions

Click one of the following links for a description of the desired string function:

• ALPHA_NUM_IN-Function
• ALPHA_NUM_OUT-Function
• COMPARE_STRING-Function
• COMPRESS-Function
• FIND_STRING-Function
• FIND_PATTERN-Function
• FIND_WORD-Function
• FOUND_STRING-Function
• FOUND_WORD-Function
• IS_ALPHA-Function
• IS_NUMERIC-Function
• LEFT-Function
• LEFT_TRIM-Function
• LENGTH-Function
• LOG-Function
• LOWER_CASE-Function
• MATCHES_PATTERN-Function
• NUM2STR-Function
• PAD_LEFT-Function
• PAD_RIGHT-Function
• PRECISION-Function
• PROPER_CASE-Function
• REPLACE_ALL-Function
• REPLACE_FIRST-Function
• RIGHT-Function
• RIGHT_TRIM-Function
• SCALE-Function
• STR2NUM-Function
• SUBSTITUTE-Function
• SUBSTRING1-Function
• SUBSTRING2-Function
• TRIM-Function
• UPPER_CASE-Function

Date Functions

Date functions act only on the day, month, and year portion of the date fields. If the source data is a timestamp, the time portion of the original source value is retained.

• ADD_DAYS-Function
• ADD_MONTHS-Function
• ADD_YEARS-Function
• CURRENT_DATE-Function
• GET_DAY-Function
• GET_WEEKDAY-Function
• GET_MONTH-Function
• GET_YEAR-Function
• SET_DAY-Function
• SET_MONTH-Function
• SET_YEAR-Function
• STR2DATE-Function

Data Privacy Functions

• APPLY_MASK-Function
• APPLY_MASK_NUMERIC-Function
• CCN_TYPE-Function
• CD_AU_ABN-Function
• CD_AU_ACN-Function
• CD_AU_TFN-Function
• CD_CA_SIN-Function
• CD_CH_RUT-Function
• CD_CN_ID-Function
• CD_MOD10_LUHN-Function
• CD_MOD11-Function
• ID_AU_TYPE-Function
• IS_ACCESS_PATH_FAILED-Function
• IS_COMPOSITE_FAILED-Function
• TO_HEX_STR-Function

Normalization Functions

Normalization Functions are not available when you access the Expression Builder during rule creation using Rule Logic.

• CCN_FIND_IN-Function
• CCN_FIND_OUT-Function
• CCN_IN-Function
• CCN_OUT-Function
• ID_AU_IN-Function
• ID_AU_OUT-Function
• ID_CA_IN-Function
• ID_CA_OUT-Function
• INTL_PHONE_IN-Function
• INTL_PHONE_OUT-Function
• PHONE_IN-Function
• PHONE_OUT-Function
• SSN_FIND_IN-Function
• SSN_FIND_OUT-Function
• SSN_IN-Function
• SSN_OUT-Function

Flow Control Functions

• SKIP_RECORD-Function
• TERMINATE_EXECUTION-Function

Custom Functions

• Custom functions are user defined, and once available, they will appear in the group of program provided functions.