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
)
text
: The input text string from which you want to extract characters.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