RIGHT(Text, Character count)
Returns the last character or characters in a text string, based on the number of characters you specify.
Text
Contains the characters to be extracted
Character count
The character count should be greater than or equal to 0.
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.
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.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy