INDEXOF(Text, Index)
Returns the character at the specified Index in the Text.
Text
String
Index
The position where the function returns the character
The Index starts from 0.
If any parameter is NULL, the result is NULL.
INDEXOF("FineDataLink",0)
F
INDEXOF("FineDataLink",2)
n
INDEXOF("FineDataLink",5)
a
For example, the following steps describe how to use the function to filter the Store_No. field ending with 3.
Add a New Calculation Column operator in the Data Transformation node and input the formula INDEXOF(Store_No.,4)="3", as shown in the following figure.
Click Data Preview to view if the Store_No. field ends with 3 in the Judgement field, as shown in the following figure.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy