String Functions
Name(parameters) | Parameter Domain | Description | Example |
---|---|---|---|
substring(string, start position, length?) |
string, number1 |
return length (or all) characters in string, starting at start position. 1st position is 1, last position is -1 |
|
string length(string) |
string |
return length of string |
string length("red") = 3 |
upper case(string) |
string |
return uppercased string |
upper case("aBc4") = "ABC4" |
lower case(string) |
string |
return lowercased string |
lower case("aBc4") = "abc4" |
substring before (string, match) |
string, string |
return substring of string before the match in string |
|
substring after (string, match) |
string, string |
return substring of string after the match in string |
|
replace(input, pattern, replacement, flags?) |
string2 |
regular expression pattern matching and replacement |
replace("abcd", "(ab)|(a)", "[1=$1][2=$2]") = "[1=ab] [2=]cd" |
contains(string, match) |
string |
does the string contain the match? |
contains("redwood", "de") = false |
starts with(string, match) |
string |
does the string start with the match? |
starts with("redwood", "re") = true |
ends with(string, match) |
string |
does the string end with the match? |
ends with("redwood", "d") = true |
matches(input, pattern, flags?) |
string2 |
does the input match the regexp pattern? |
matches("redwood", "^re*w") = true |