Excel Text Functions (MDX)

A set of Excel like functions supported by icCube

void

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.