RIGHT - Returning the Last Character(s) in a String- FineDataLink Help Document

Last update: May 30, 2025

Overview

Syntax	RIGHT(Text, Character count)	Returns the last character or characters in a text string, based on the number of characters you specify.
Parameter 1	Text	Contains the characters to be extracted
Parameter 2	Character count	The character count should be greater than or equal to 0.
Return Value Type	Text

Notes

The function supports two parameters. The first is of the text type. The second is of the numeric type and can be omitted.
If character count exceeds the length of text, the RIGHT() function returns all text. If character count is not specified, the default value is 1.
If any parameter is NULL, the result is NULL.

Example

Formula	Result	Note
RIGHT("It is interesting",6)	esting	/
RIGHT("Share Holder")	r	/
RIGHT("Huge sale",4)	sale	/

For example, to extract the last four digits of the Channel_ID field, add a New Calculation Column operator in the Data Transformation node, and input the formula RIGHT(Channel_ID,4), as shown in the following figure.

Click Data Preview to view the obtained data in the new column, as shown in the following figure.

Previous：MID - Returning a Substring from the Specified Position of a Text String

Next：LEFT - Returning the First Character(s) in a String

Helpful
Not helpful
Only read

中文（简体）

English

RIGHT - Returning the Last Character(s) in a String

Overview

Notes

Example

附件列表