Function | Description |
---|---|
Filter(InputStrings, Value
[, Include</br>[, Compare]]) | Selects strings from an array of strings (InputStrings), based on the criteria passed as an argument. Value is the string to be searched.
Include is an optional boolean value indicating whether the search should return strings containing a particular substring (True or False). compare is an optional argument corresponding to a numeric value indicating the kind of comparison:
|
FormatCurrency(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]]) | Returns a formatted monetary value based on the monetary symbol defined in the system control panel. NumDigitsAfterDecimal is an optional argument
specifying the number of digits to be displayed after the decimal point. IncludeLeadingDigit is an optional argument specifying whether the 0(zeros) located at the end should be displayed or not. IncludeLeadingDigit can have one of the following status:
UseParensForNegativeNumbers is an optional argument specifying whether or not negative numbers must be written in brackets.. UseParensForNegativeNumbers may have the same status as IncludeLeadingDigit. GroupDigits is also an optional constant can take the same three states. It defines whether groups of numbers (thousands) must be separated for readability.. |
FormatDateTime(Date[, NamedFormat]) | Returns an expression formatted as a date or time. The NamedFormat is an optional argument that can take the following values:
|
FormatNumber(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]]) | Returns a formatted number. NumDigitsAfterDecimal is an optional argument specifying the number of digits to be displayed after the decimal point.
IncludeLeadingDigit is an optional argument specifying whether the 0 located at the end should be displayed or not. IncludeLeadingDigit can have 3 states :
UseParensForNegativeNumbers is an optional argument specifying whether negative numbers must be written in brackets. UseParensForNegativeNumbers can have the same 3 states as IncludeLeadingDigit. GroupDigits is also an optional constant can take the same three states. It defines whether groups of numbers (thousands) must be separated for readability... |
FormatPercent(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]]) | Returns an expression formatted as a percentage (ending with %). NumDigitsAfterDecimal is an optional argument specifying the number of digits to
display after the decimal point. IncludeLeadingDigit is an optional argument specifying whether the 0 located at the end should be displayed or not. IncludeLeadingDigit can take one of the following three states::
UseParensForNegativeNumbers is an optional argument specifying whether negative numbers must be written in brackets. UseParensForNegativeNumbers can have the same 3 states as IncludeLeadingDigit. Enfin GroupDigits is also an optional constant can take the same three states. It defines whether groups of numbers (thousands) must be separated for readability. |
InStr([start, ]string1, string2[, compare]) | Returns the position of the first occurrence of a string of characters (string2) in another one (string1). start is an optional argument defining the
character position where the search begins. |
InStrRev([start, ]string1, string2[, compare]) | Returns the position of the first occurrence of a string of characters (string2) in another one (string1), starting from the end.
start is an optional argument defining the character position where the search begins. compare is an optional argument corresponding to a numeric value, indicating the kind of comparison:
|
Join(list[, delimiter]) | Returns a string assembled from separate elements in the list array.
delimiter delimiter is an optional character used to delimit the substrings in the returned result. Default substrings are separated by spaces. |
LCase(string) | Converts the string to lowercase string. |
Left(string, length) | Returns a specified number of characters (length) from the left of the string. |
Len(string > varname) | Returns the number of characters in a string or the number of bytes required to store a variable |
LTrim(string) | Returns a copy of the string without spaces from the beginning. |
Mid(string, start[, length]) | Returns a specified number (length) of characters from (string).
start ddetermines the character position where the output string must begin. |
Replace(expression, find, replacewith[, start[, count[, compare]]]) | Search and replace a substring in a string. expression correspond to the string to be searched. find correspond to the substring to be
searched in the expression. replacewith correspond to the substring that will replace the occurences of the find substring. start, count and compare are optional arguments that will define, where to start the search (default 1), the number of substitutions to be done (by default -1) and the type of comparaison to be made. compare is an optional argument corresponding to a numeric value, indicating the kind of comparison::
|
Right(string, length) | Returns a number of characters (length) from the right of the string. |
Rtrim(string) | Returns a copy of the string without the spaces at the end. |
Space(number) | Returns a string consisting of the number of spaces passed as a parameter. |
Split(expression[, delimiter[, count[, compare]]]) | Returns a one-dimensional array containing a specified number of substrings. delimiter is an optional character that delimits substrings (by default a
space is used). count is an optional argument that defines the maximum number of substrings to be returned. By default count is equal to -1,indicating that there is no limit.compare is an optional argument corresponding to a numeric value, indicating the kind of comparison:
|
StrComp(string1, string2[, compare]) | Returns the result of the comparison of strings string1 and string2. If string1 is less than string2, StrComp returns -1. If string1 is equal to string2, StrComp returns 0. If string1 is greater than string2, StrComp returns 1. Finally, if string1 or string2 is Null, then StrComp returns Null.
compare is an optional argument corresponding to a numeric value, indicating the kind of comparison:
|
String(number, character) | Returns a string of characters of length number repeating a specific character. |
StrReverse(string1) | Reverses the order of characters in string1. |
Trim(string) | Returns a copy of the string without the spaces at the beginning and the end. |
UCase(string) | Converts the string to uppercase. |