Search…
⌃K

String

Contains

Returns true if a string contains a given substring.

Expression:

CONTAINS(string: string, substring: string)

Return:

boolean

Example of usage:

CONTAINS("The Lord of the Rings", "Harry Potter")
Return value:
false

Starts With

Returns true if a string starts with a given substring.

Expression:

STARTS_WITH(string: string, substring: string)

Return:

boolean

Example of usage:

STARTS_WITH("Some sentence.", "Some")
Return value:
true

Concatenate

Returns a concatenated string.

Expression:

CONCAT(string1: string, string2: string, string?: string)

Return:

concatString: string

Example of usage:

CONCAT("Dumb and ","Dumber")
Return value:
"Dumb and Dumber"

Lowercase

Returns a converted string into lowercase.

Expression:

LOWERCASE(value: string)

Return:

lowercaseString: string

Example of usage:

LOWERCASE("MAKING THIS SENTENCE LOWERCASE")
Return value:
"making this sentence lowercase"

Uppercase

Returns a converted string into lowercase.

Expression:

UPPERCASE(value: string)

Return:

uppercaseString: string

Example of usage:

UPPERCASE("making this sentence uppercase")
Return value:
"MAKING THIS SENTENCE UPPERCASE"

Is Empty

Returns true if a value is an empty string.

Expression:

ISEMPTY(value: string)

Return:

boolean

Example of usage:

ISEMPTY("")
Return value:
true

Empty String to Null

Returns null if a value is empty. Otherwise returns the value as is.

Expression:

EMPTYNULL(value: string)

Return:

null || string

Example of usage:

EMPTYNULL("")
Return value:
null

Split

Returns an exact number of split strings to an array using a separator.

Expression:

SPLIT(value: string, delimiter: string, maximumElements?: integer)

Return:

splitString: array

Example of usage:

SPLIT("My precious | muppet wife", "|")
SPLIT("My precious | muppet wife", "|", 1)
Return value:
["My precious ", " muppet wife"]
["My precious "]

Substring

Returns a trimmed string bordered by index numbers.

Expression:

SUBSTRING(inputString: string, start: integer, end: integer)

Return:

trimmedString: string

Example of usage:

SUBSTRING("Birds of Paradise", 0, 3)
Return value:
"Bir"

Replace

Returns a string; a matched one replaces its pattern.

Expression:

REPLACE(inputString: string, searchPattern: string, replacedPattern: string)

Return:

replacedString: string

Example of usage:

REPLACE("Birds of Paradise", "Birds", "Lions")
Return value:
"Lions of Paradise"

Join Array to a String

Returns a string of joined array elements with string separators.

Expression:

JOIN(value: array, separator: string)

Return:

joinedString: string

Example of usage:

JOIN(["first", "second", "third"]," -> ")
Return value:
"first -> second -> third"

String Lenght

Returns a number of characters by a given string.

Expression:

STRLEN(value: string)

Return:

numberOfCharacters: integer

Example of usage:

STRLEN("Count my sentence.")
Return value:
18
Last modified 6mo ago