Skip to main content
RIGHT_PART

Retrieves the rightmost characters from a text string.

Updated over a month ago

Description

The RIGHT_PART() function allows you to extract a specified number of characters from the end (right side) of a text string. This is useful for tasks like truncating text or extracting suffixes from text.

Syntax

RIGHT_PART(text, number)

Output

text

Variables

  1. text: The input text string from which you want to extract characters.

  2. number: The number (length) of characters to extract from the right side of the text.

Example

RIGHT_PART(`Original Text`, 5)

ID

Original Text

RIGHT_PART

1

Hello, World!

orld!

2

Example Text

Text

3

Savant Analytics

ytics

Did this answer your question?