Text Functions (Report Builder 1.0)
Use Text functions to manipulate the text in your report. For example, suppose you want cities and states to be displayed together. Using the CONCAT function, you can create a field where both are displayed together.
Text functions can use the following data types: String and Integer.
Concatenates two strings together into one.
Position of the first instance of a string.
Returns the left most characters of a string.
Returns the number of characters in a string.
Converts a string from uppercase characters to lowercase.
Returns a string with the leading spaces removed.
Returns a string with all the instances of a sub-string replaced by another sub-string.
Returns the right most characters of a string.
Returns a string with the trailing spaces removed.
Returns a sub-string from within a string.
Converts a string from lowercase characters to uppercase.