Text Functions

Use Text functions to manipulate the text in your report. Text functions can use the following data types: String and Integer.

String manipulation:

Function	Description
Format(format, value)	Formats the value using the specified format string. Example:=Format(' LineTotal: {0} ', Fields.LineTotal) Detailed information about date and time format specifiers can be found in Standard Date and Time Format Strings and Custom Date and Time Format Strings articles.
FormatWithCulture(cultureName, format, args)	Formats the value using the specified format string and culture name. Example:=FormatWithCulture("en-GB", "Price: {0:C}", Fields.Price) To use invariant culture, the first argument must be an empty string. Detailed information about culture names can be found in Windows Language Code Identifier (LCID) Reference article.
IndexOfSubstr(string, substring)	Returns the index of the first occurrence of a string, within the specified text.
IsValidXhtml(markup)	Determines if the provided markup is valid XHTML that HtmlTextBox can parse.
HtmlEncode(value)	HTML-encodes a text and returns the encoded text. For example: =HtmlEncode("&Telerik") will return &Telerik
HtmlDecode(value)	Converts a text that has been HTML-encoded, into a decoded text. For example: =HtmlDecode("&Telerik") will return &Telerik
Join(separator, strings)	Returns a string created by joining a number of substrings contained in an array.
Len(string)	Gets the number of characters in a string.
Replace(string, oldSubstring, newSubstring)	Returns a new string in which all occurrences of a substring in the current string are replaced with another specified substring.
Space(count)	Returns a string consisting of the specified number of spaces.
Split(separator, string)	Returns a string array that contains the substrings in this instance that are delimited by the specified separator.
StringCompare(stringA, stringB)	Compares two specified strings and returns an integer that indicates their relative position in the sort order.
StripHtmlTags(string)	Strips the HTML tags from the input text.
Substr(string, startIndex, length)	Retrieves a substring from a string. The substring starts at a specified character position and has a specified length. Example:=SubStr("Telerik", 0, 3) returns "Tel".
ToLower(string)	Returns a copy of the specified string converted to lowercase.
ToUpper(string)	Returns a copy of the specified string converted to uppercase.
Trim(string)	Removes all leading and trailing whitespace from the passed in string.
TrimEnd(string)	Removes all occurrences of white space characters from the end of this instance.
TrimStart(string)	Removes all occurrences of white space characters from the beginning of this instance