RIGHT_SUBSTR

Extracts the rightmost characters of a text string up to a specified length

Description

The RIGHT_SUBSTR() function is used to extract a specified number of rightmost characters from the end of a text string. It's useful for tasks like truncating text or extracting suffixes from text.

Syntax

RIGHT_SUBSTR(text, number)

  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

Table

ID
Original Text

1

Hello, World!

2

Example Text

3

Savant Analytics

Function

RIGHT_SUBSTR(`Original Text`, 5)

Results

RIGHT_SUBSTR (text)

d, World!

t Text

ytics

Last updated