String

Concat

Concatenates multiple strings into a single string. Treats NULL values as an empty string. –> learn more

CONCAT(@expression)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variables or literals	any string	true	-

Ends with

Determines whether a string is a suffix of another string –> learn more

ENDS_WITH(@expression, @expression_2)

Return type

boolean

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@expression_2	variable or literal	any string	true	-

Format string

Creates a formatted string from input variables. Similar to the C printf function. –> learn more

FORMAT(@format_string, @expression)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variables or literals	any string, integer, float, date, dateTime, time	true	-
@format_string	literal	any string	true	-

Length

Returns the number of characters in a string variable –> learn more

LENGTH(@variable)

Return type

integer

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any string	true	-

Lower case

Return string value to lowercase –> learn more

LOWER(@variable)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any string	true	-

Pad left

Pad a string to the left with characters up to a certain total length –> learn more

LPAD(@variable, @return_length[, @pattern])

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any string	true	-
@pattern	variable or literal	any string	false	-
@return_length	variable or literal	any integer	true	-

Trim left

Removes all leading characters that match the provided pattern –> learn more

LTRIM(@expression[, @pattern])

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@pattern	variable or literal	any Redivis type	false	-

Normalize

Normalization is used to ensure that two strings are equivalent. Normalization is often used in situations in which two strings render the same on the screen but have different Unicode code points. –> learn more

NORMALIZE(@variable[, @normalization_mode])

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any string	true	-
@normalization_mode	enum	any of: NFC, NFKC, NFD, NFKD	false	(NFC (default))

Regexp contains

Match a variable's values against a regular expression –> learn more

REGEXP_CONTAINS(@variable, @regex)

Return type

boolean

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any string	true	-
@regex	literal	any Redivis type	true	-

Regexp extract

Returns the first substring that matches a regular expression –> learn more

REGEXP_EXTRACT(@variable, @regex)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any string	true	-
@regex	literal	any Redivis type	true	-

Regexp replace

Replaces all substrings that match a given regular expression with a new string –> learn more

REGEXP_REPLACE(@variable, @regex, @expression_2)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any string	true	-
@regex	literal	any Redivis type	true	-
@expression_2	variable or literal	any string	false	-

Repeat

Return a string of a provided value repeated a set number of times –> learn more

REPEAT(@expression, @literal)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@literal	literal	any integer	true	-

Replace

Replaces all substrings that match a given string with a replacement string –> learn more

REPLACE(@expression, @match, @expression_2)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@match	variable or literal	any string	true	-
@expression_2	variable or literal	any string	false	-

Reverse

Reverses a string –> learn more

REVERSE(@expression)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-

Pad right

Pad a string to the right with characters up to a certain total length –> learn more

RPAD(@variable, @return_length[, @pattern])

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any string	true	-
@pattern	variable or literal	any string	false	-
@return_length	variable or literal	any integer	true	-

Trim right

Removes all trailing characters that match the provided pattern –> learn more

RTRIM(@expression[, @pattern])

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@pattern	variable or literal	any Redivis type	false	-

Starts with

Determines whether a string is a prefix of another string –> learn more

STARTS_WITH(@expression, @expression_2)

Return type

boolean

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@expression_2	variable or literal	any string	true	-

String position

Returns the 1-based index of the first occurrence of a substring within a string. Returns 0 if not found. –> learn more

STRPOS(@expression, @match)

Return type

integer

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@match	variable or literal	any string	true	-

Substring

Return the substring of a specified string –> learn more

SUBSTR(@expression, @position[, @length])

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@position	variable or literal	any integer	true	-
@length	variable or literal	any integer	false	-

Trim

Removes all leading and trailing characters that match the provided pattern –> learn more

TRIM(@expression[, @pattern])

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@pattern	variable or literal	any Redivis type	false	-

Upper case

Return string value to uppercase –> learn more

UPPER(@variable)

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any string	true	-