INDEXOF - Returning the Character at a Specified Position in the Text- FineDataLink Help Document

Last update: May 30, 2025

Overview

Syntax	INDEXOF(Text, Index)	Returns the character at the specified Index in the Text.
Parameter 1	Text	String
Parameter 2	Index	The position where the function returns the character
Return Value Type	Text

Notes

The Index starts from 0.
If any parameter is NULL, the result is NULL.

Example

Formula	Result	Note
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.

Note:

As the INDEXOF() function returns data of the text type, you need to enclose the value 3 in quotation marks ("") to convert it into the text type.

Click Data Preview to view if the Store_No. field ends with 3 in the Judgement field, as shown in the following figure.

Previous：REPLACE - Replacing a Substring in a String

Next：FIND - Returning the Position of a Specified Substring in a String

Helpful
Not helpful
Only read

中文（简体）

English

INDEXOF - Returning the Character at a Specified Position in the Text

Overview

Notes

Example

附件列表