FNC_PARSE_OBJECTIVE

Business Intelligence (BI) Interface Guide › Business Intelligence Interface › SQL Interfaces › Utility Functions › FNC_PARSE_OBJECTIVE_STATEMENT

FNC_PARSE_OBJECTIVE_STATEMENT

Description

Used for setting the correct decimal separator and date format in an Objective Statement text.

Syntax

FNC_PARSE_OBJECTIVE_STATEMENT (TEXT, SEPARATOR, DATE_FORMAT)

Parameters

Name	Type	Description
Text	objective_statement_text	The objective statement text.
Separator	char	The decimal separator to use.
Date_Format	varchar2	The date format to use.

Return Value

Returns the Objective Statement, with all numbers formatted with the selected decimal separator, and with all dates formatted with the selected date format.

Remarks

The default decimal separator is a period (.).

Example

FNC_PARSE_OBJECTIVE_STATEMENT ('No less than #99.97% per each Month', ',', 'MM/DD/YYYY')

returns

'No less than 99,97% per each Month'