fbpx

Excel Text Functions (MDX)

A set of Excel like functions supported by icCube

Return

void

Description


A list of Excel Text functions to follow MDX standard.


  • Len(string s), returns the number of characters of the string parameter.
  • LCase(string s), returns the string parameter converted to lowercase.
  • Lower(string s), returns the string parameter converted to lowercase.
  • UCase(string s), returns the string parameter converted to uppercase.
  • Upper(string s), returns the string parameter converted to uppercase.
  • Trim(string s), returns the string without left and right
  • Mid(string s, int start, int length), returns the substring starting at start with the parameter length
  • Left(string s, int length), returns a string containing the specified length from the left side of a string parameter.
  • Right(string s, int length), returns a string containing the specified length of characters from the right side of a string parameter.
  • Concatenate(string s1,string s2 .. string s100), returns a string as concatenation of the parameter strings.
  • Exact(string s1, string s2), returns true if both string are equal (case sensitive)
  • Replace(string s, string target, string replacement), replaces each substring of this string that matches the literal target sequence with the specified literal replacement sequence.
  • Instr([int start,]string s1, string s2), returns the position of the first occurrence of string s2 within s1 (case insensitive). The optional parameter start set the starting position for the search.

See Also

Java Functions

Examples

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.