String
Returns true if a string contains a given substring.
CONTAINS(string: string, substring: string)
boolean
CONTAINS("The Lord of the Rings", "Harry Potter")
Return value:
false
Returns true if a string starts with a given substring.
STARTS_WITH(string: string, substring: string)
boolean
STARTS_WITH("Some sentence.", "Some")
Return value:
true
Returns a concatenated string.
CONCAT(string1: string, string2: string, string?: string)
concatString: string
CONCAT("Dumb and ","Dumber")
Return value:
"Dumb and Dumber"
Returns a converted string into lowercase.
LOWERCASE(value: string)
lowercaseString: string
LOWERCASE("MAKING THIS SENTENCE LOWERCASE")
Return value:
"making this sentence lowercase"
Returns a converted string into lowercase.
UPPERCASE(value: string)
uppercaseString: string
UPPERCASE("making this sentence uppercase")
Return value:
"MAKING THIS SENTENCE UPPERCASE"
Returns true if a value is an empty string.
ISEMPTY(value: string)
boolean
ISEMPTY("")
Return value:
true
Returns null if a value is empty. Otherwise returns the value as is.
EMPTYNULL(value: string)
null || string
EMPTYNULL("")
Return value:
null
Returns an exact number of split strings to an array using a separator.
SPLIT(value: string, delimiter: string, maximumElements?: integer)
splitString: array
SPLIT("My precious | muppet wife", "|")
SPLIT("My precious | muppet wife", "|", 1)
Return value:
["My precious ", " muppet wife"]
["My precious "]
Returns a trimmed string bordered by index numbers.
SUBSTRING(inputString: string, start: integer, end: integer)
trimmedString: string
SUBSTRING("Birds of Paradise", 0, 3)
Return value:
"Bir"
Returns a string; a matched one replaces its pattern.
REPLACE(inputString: string, searchPattern: string, replacedPattern: string)
replacedString: string
REPLACE("Birds of Paradise", "Birds", "Lions")
Return value:
"Lions of Paradise"
Returns a string of joined array elements with string separators.
JOIN(value: array, separator: string)
joinedString: string
JOIN(["first", "second", "third"]," -> ")
Return value:
"first -> second -> third"
Returns a number of characters by a given string.
STRLEN(value: string)
numberOfCharacters: integer
STRLEN("Count my sentence.")
Return value:
18
Last modified 1yr ago