|
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.
Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement | |
Conello © 2000-2003 Feedback |