String Functions
String data is character or textual data. It is common to parse or manipulate text values for presentation purposes in a report. The built-in string functions provide many formatting options.Asc Returns the ASCII code for the first character in a given string.AscW Returns the Unicode value for the first character in a given string.Chr Returns a character given an ASCII code.ChrW Returns a Unicode character given an ASCII code.Filter Searches an array for a given value.InStr Searches a string for a given value.InStrRev Searches a string for a given value by starting at the last character in the string and searching down to the first.Join Converts a list of multiple elements to a single string containing all the element values.Left Returns the leftmost characters in a given string for the number of characters specified.Length When Basic Syntax is used, Len(x) is also acceptable usage.LowerCase Converts a value to lowercase.Mid Extracts part of a string based on a starting position in the string and a given number of characters to extract.NumericText Returns True if the content of a text string is a valid number.ProperCase (string) Returns a string with initial capitalization on each word.Replace Returns a string that has had values replaced based on a pattern passed to this function.ReplicateString Make a specified number of copies of a text string.Right Returns the rightmost characters in a given string for the number of characters specified.Roman Returns a Roman numeral corresponding to an integer value.Space Returns a specified number of blank spaces.Split Converts the words in a string into a list of multiple elements.StrCmp Compares two strings to one another.StrReverse Reverses the characters in a string. ToNumber Converts a given value to a double value.ToText Converts a given value to a text string; the following example truncates a number to 0 decimals and then converts it to a text string:
ToText({Table.Field},00,")
ToWords Converts a number to a text string with an opportunity to handle decimal conversion.Trim Removes leading and trailing blanks from a string.TrimLeft Removes blanks at the beginning of a string (leading) from the string.TrimRight Removes blanks at the end of a string (trailing) from the string.UpperCase Converts a value to uppercase.Val Extracts a numeric value from the text string in which it is embedded.