The truncate function returns number truncated to integer places right of the decimal point. Removes the trailing white spaces in a string. Removes the leading white spaces in a string. Enter the text to be trimmed, the function returns the trimmed text. Pad_string is the string that will be padded to the right-hand side of string1 trim() String1 is the string to pad characters to (the right-hand side). The rpad function pads the right side of a string with a specific set of characters. Pad_string is the string that will be padded to the left-hand side of string1. Padded_length is the number of characters to return. String1 is the string to pad characters to (the left-hand side). The lpad function pads the left side of a string with a specific set of characters. The supported functions are shown in the following table: SQL Statement or XSL Expression For example, assume you had two elements, FIRST_NAME and LAST_NAME that you wanted to concatenate into a 30-character field and right pad the field with the character 'x', you could NOT use the following:Д«ecause concat is an XSL expression. Note: You cannot mix xdofx statements with XSL expressions in the same context. The syntax for these extended functions is Oracle Business Intelligence Publisher Report Designer's GuideД®xtended Function Support in RTF Templates Extended SQL and XSL FunctionsД«I Publisher has extended a set of SQL and XSL functions for use in RTF templates. Oracle Business Intelligence Publisher Report Designer's Guide Browser version script Skip Headers

Bi publisher rtf template functions