RIGHT Function

The RIGHT function extracts a specified number of characters from a string's right (end) side. This string can be a column reference or a string literal.

Key Points:

  • The RIGHT function requires an integer value that defines the number of characters to extract from the end of the string.

  • Since the RIGHT function extracts characters based on a fixed numeric value, changes to the length or structure of a data field may cause the recipe to fail or produce incorrect results.

Basic Usage

Property Reference Example:

=RIGHT(GetProperty("Start Year"); 4)

  • Output: Returns the rightmost (last) four characters of the Start Year property value.

String Literal Example:

=RIGHT("Hello, World"; 5)

Output: Returns the string: World.

Search