Mid (string, start [, integer])
|
Returns n characters from the string starting from the start location.
For example:
Mid ("Adams", 2, 2)
returns "da"
Mid ("Adams", 2)
returns "dams".
|
InStr (string1, string2 [, start] [, compare])
|
The position of the first character of string2 in string1.
[,start] is used to specify the position in string1 to begin the search, where the first character in the string is 1. If start is negative, InStr searches backwards.
[,compare] is used to specify if the comparison of strings is case sensitive. Enter 0 for a case-sensitive search, enter 1 for a case-insensitive search.
For example:
InStr ("foo", "oo")
returns 2.
InStr ("bda", "Adams", 2)
returns 2.
InStr ("BDA", "Adams", 2, 1)
returns 2.
If the string is not found, the function returns 0.
|
InList (string1, comma-separated list)
|
Returns if string1 occurs one or more times in a comma-separated list.
For example:
InList("foo", "abc,boo,foo")
returns TRUE.
|