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. |
| 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 |