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

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.