toString(expression)
| Cast operation that converts the value of expression to a string. | String | toString(123) returns "123"
|
startsWith("string", "prefix")
|
Checks if the string begins with the prefix.
An alternative form of beginsWith(). | Boolean | startsWith("Exabeam", "Exa") returns true
|
beginsWith("string", "prefix")
|
Checks if the string begins with the prefix.
An alternative form of startsWith(). | Boolean | beginsWith("Exabeam", "Exa" returns true
|
startsWithAny("string", "p1", ..., "pn")
|
Checks if string begins with any of the prefixes p1 ... pn.
An alternative form of beginswithAny(). | Boolean | startsWithAny("Exabeam", "Exa", "123", "Prefix) returns true
|
beginswithAny("string", "p1", ..., "pn")
|
Checks if string begins with any of the prefixes p1 ... pn.
An alternative form of startswithAny(). | Boolean | beginswithAny("Exabeam", "Exa", "123", "Prefix) returns true
|
lcp("s1", ..., "sn")
| Evaluates the longest common prefix among string arguments s1 ... sn. An alternative form of LeastCommonPrefix(). | String | lcp("Exabeam", "Exameter") returns "Exa"
|
LeastCommonPrefix("s1", ..., "sn")
| Evaluates the longest common prefix among string arguments s1 ... sn. An alternative form of lps(). | String | LeastCommonPrefix("Exabeam", "Exameter") returns "Exa"
|
lcs("s1", ..., "sn")
| Evaluates the longest common suffix among string arguments s1 ... sn. The evaluation is case-sensitive. An alternative form of LeastCommonSuffix(). | String | lcs("Exabeam", "Jim Beam") returns "eam"
|
LeastCommonSuffix("s1", ..., "sn")
| Evaluates the longest common suffix among string arguments s1 ... sn. The evaluation is case-sensitive. An alternative form of lcs(). | String | LeastCommonSuffix("Exabeam", "Jim Beam") returns "eam"
|
endsWith("string", "substring")
|
Checks whether string ends with substring.
| Boolean | endsWith("filename.txt", ".txt") returns true
|
endsWithAny("string", "s1", ..., "sn")
|
Checks if string ends with any of the substrings s1, ..., sn.
| Boolean | endsWithAny("filename.txt", ", ".txt", ".pdf", ".docx") returns true.
|
concat("s1", ..., "sn")
|
Concatenates arguments as a single string. | String | concat("hello", " ", "world") returns "hello world"
|
joinifexists(f1", ..., fn)
| Concatenates value of fields f1 ..., fn if all field values are non-empty; otherwise, returns an empty string or null. | String | joinifexists(first_name, " " ", last_name) returns "Barbara Salazar" if first_name is Barbara and last_name in Salazar
|
contains("string", "substring")
|
Checks whether string contains substring.
| Boolean | contains("exabeam", "beam") returns true
|
containsAny("string", "s1", ..., "sn")
|
Checks whether string contains any of the substrings s1, ..., sn.
| Boolean | contains("exabeam", "exa", "acme") returns true
|
slice("string", from, until)
| Extracts a substring from string starting at index from and up to but not including index until. | String | slice("hello', 2, 4) returns "ll"
|
replace("string", "s1", "s2")
| In string, replace every substring s1, interpreted as a literal string, with substring s2. | String | replace("Exabeam", "beam", "meter") returns "Exameter"
|
replaceAll("string", regex, "s2")
| In string, replaces every occurrence of substring that matches a regular expression regex with substring s2. | String | replaceAll("Hello Exabeam Hello Exabeam", /Exabeam/, "Barbara") returns "Hello Barbara Hello Barbara"
|
replaceFirst("string", regex, "s2"
| In string, replaces the first occurrence of a substring that matches regular expression regex with substring s2. | | replaceFirst("Hello Exabeam Hello Exabeam", /Exabeam/, "Barbara") returns "Hello Barbara Hello Exabeam"
|
take("string",n)
| Keeps first n characters in string and removes the rest. | String | take("hello", 2) returns "he"
|
takeright("string", n)
| Keeps last n characters in string and removes the rest. | String | takeright("hello" 2) returns "lo"
|
chopBefore("string", "pattern", n)
|
Removes all characters from string before and including the n-th occurrence of a pattern.
| String | chopBefore("a.b.c", ".", 2) returns "c"
|
chopAfter("string", "pattern", n)
|
Removes all characters from string after and including the n-th occurrence of a pattern.
| String | chopAfter("a.b.c", ".", 2) returns "a.b".
|
drop("string"
, n)
|
Removes the first n characters from string.
| String | drop("hello", 2) returns "llo"
|
dropright("string", n)
|
Removes the last n characters from string.
| String | dropright("hello", 2) returns "hel"
|
stripPrefix("string", "prefix")
| Removes prefix from string if present. The prefix argument is case sensitive. | String | stripPrefix("Exabeam", "Exa") returns "beam"
|
stripSuffix("string", "suffix")
| Removes suffix from string if present. The prefix argument is case sensitive. | String | stripSuffix("Exabeam", "beam" returns "Exa"
|
trim("string")
| Remove leading and trailing whitespace from string. | String | trim(" Exabeam ") returns "Exabeam"
|
toLower("string")
| Converts string to all lowercase. | String | toLower("HELLO") returns "hello"
|
toUpper("string")
| Converts string to all uppercase. | String | toUpper("hello") returns "HELLO"
|
indexOf("string", "pattern")
|
Evaluates the zero-based index of the first occurrence of pattern in string. If pattern is not present, returns -1. | Integer | indexOf("hello", "e") returns 1
|
lastIndexOf("string","pattern")
| Evaluates the zero-based index of the last occurence of pattern in string. If pattern is not present, returns -1. | Integer | lastIndexOf("hello", "l") returns 3
|
length("string")
| Evaluates the length of string. | Integer | length("hello") returns 5
|
format("formatspec", argument)
| Formats argument according to format string formatspec. | Formatted argument | format("%.2f", 2.34567) returns 2.35.
|
