Description
Extracts a given number of characters from a Text, starting from the last character to the first.
Syntax
RIGHT(Text to Extract, Number of Characters)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Text to Extract (required) | Text | Any Dimensions | Text to extract characters from. |
| Number of Characters (required) | Integer | No Dimension or Dimensions of Text to Extract | Number of characters to extract from the end of the text. |
Returns
| Type | Dimensions |
|---|---|
| Text | Dimensions of Text to Extract |
Extracted characters from Text to Extract.
BLANK if Number of Characters is a negative integer.
Examples
| Formula | Result | Description |
|---|---|---|
RIGHT(“abc”, 5) | “abc” | All characters are extracted from “abc”. |
RIGHT(“abcd”, 2) | “cd” | Only the last two characters are extracted from “abcd”. |
RIGHT(“a”, -1) | BLANK | The Number of Characters, -1, is invalid. |
See also
Excel: RIGHT
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
