Siebel Reporting XSLFunctions Library Methods in Siebel BI Publisher

XSLFunctions (XSLFunctions.jar) is the library for common functions used in standard Siebel BI Publisher reports. Following are the methods supported: current_date() Method returns the current date in the standard XSD date format. Returns: current date as string --- current_time() Method returns the current time in the native time format. Returns: the current time as string --- phoneFormat(inp) Method to returns a String, which is the usual way to display the phone or fax number i.e. (XXX)AAA-BBBB Parameters: inp - Phone number to be formatted Returns: Formatted phone number as string --- trim(text) Method to remove leading and trailing white spaces in a string. Parameters: text - the text to be trimmed. Returns: the trimmed text --- ltrim(text) Method to remove the leading white spaces in a string Parameters: text - the text to be trimmed Returns: the trimmed text --- rtrim(text) Method to remove the trailing white spaces in a string Parameters: text - the text to be trimmed Returns: the trimmed text --- trimleft(text) Method to remove the leading white spaces in a string Parameters: text - the text to be trimmed Returns: the trimmed text --- trimright(text) Method to remove the trailing white spaces in a string Parameters: text - the text to be trimmed Returns: the trimmed text --- length(text) Method to return the length of a string Parameters: text - the text whose length is required Returns: the length of the text --- lower_case(text) Method to convert a text string to lower case Parameters: text - the text to be converted to lower case Returns: the lower case string --- upper_case(text) Method to convert a text string to upper case Parameters: text - the text to be converted to upper case Returns: the upper case string --- chr(int charnumber) Method returns a character for a given number Parameters: charnumber - charnumber the number of the character Returns: the character --- now() Method to return the current time in the native time format. Returns: the current time as string --- left(text, int numChars) Method to return the String, which contains specified (numChars no of characters) leading characters. Parameters: text - Input String numChars - Number of characters to retrieve. Returns: leftmost numChars characters --- DivIntZero(int div, int divisor) Method returns a 0 if the divisor is a zero. Otherwise returns the normal division * result. Parameters: div - numerator of the fraction divisor - denominator of the fraction Returns: numeric value of the division or 0 --- right(text, int numChars) Method to return the String, which contains specified (numChars no of characters) trailing characters. Parameters: text - Input String numChars - Number of characters to retrieve. Returns: rightmost numChars characters --- ToDbl(input) Method to converts a string input to a double value Parameters: input - Input String Returns: double value --- Val(input) Method to Returns the numeric value of a string expression. Parameters: input - String expression from which to extract numeric value. Returns: numeric value --- sum(list) Method to Sum the values in the nodelist Parameters: list - List of objects Returns: Sum value --- sumVal(list) Method to Sum the values in the nodelist after rounding the values Parameters: list - List of objects Returns: Sum value --- toText(double d) Converts the double value to string Parameters: d - number required to be converted Returns: Coverted String --- toText(double d, int len) A number specifying how many decimal places of x to include in the string [optional, default is 2]. Parameters: d - the number to be formatted len - number indicating the number of the decimal places to carry the value. Returns: Formatted String --- toText(double d, int len, s1, s2) The character to separate thousands (s1) with and the character to use for the decimal point (s2). Parameters: d - the number to be formatted len - number indicating the number of the decimal places to carry the value s1 - single character as thousand separator. s2 - single character as decimal separator. Returns: Formatted String --- toTextPat(double d, pat) Method to return the double d in the format specified as pattern Parameters: d - the number to be formatted pat - pattern for formatting Returns: Formatted String --- totext(d) Method to return the date as the date instance of the input date, which is in format yyyy- MM-dd. Parameters: d - Date string Returns: Formatted Date String --- totext(d, f) Method to return the date in the format "f" of the input date, which is in format yyyy-MM- dd. Parameters: d - Date string f - format for Date string Returns: Formatted Date String --- totext(d, f, e) Method to return the date "d" the format "f" of the input date, which is in format " e ". format yyyy-MM-dd. Parameters: d - Date string f - output format for Date string e - input format for Date string Returns: Formatted Date String --- lineTrimLeft(inp, int len) Method to return the complete words, which occur within the length len Parameters: inp - String to be trimmed len - number of characters Returns: Formatted Date String --- chrS(int charnumber) Returns the character that corresponds to the specified character code in the current run time encoding. Parameters: charnumber - A numeric expression that represents the character code. Returns: characters for the code --- Format(expr, format) Method to return the formatted string for input expression according to the format, which can be "Currency","Date" or "String". Parameters: expr - String to be formatted. format - format. Returns: Formatted string --- Format(expr, format, locale) Method to return the string as the currency formatted according to the locale and as per the format specified. Parameters: expr - Currency to be formatted. format - Required format locale - Locale Returns: Formatted Currency --- FormatCurr FormatCurr(expr, locale) Method to return the string as the currency formatted according to the locale. Parameters: expr - Currency to be formatted. locale - Locale Returns: Formatted Currency --- getCanonicalDate(input) Method to convert the date value in string format into the canonical format for use with BI Publisher date functions. Parameters: input – date string or field. Returns: Formatted date in canonical format