FIND - Returning the Position of a Specified Substring in a String- FineDataLink Help Document

Last update: May 30, 2025

Overview

Syntax	FIND(Text 1, Text 2, Index)	Returns the index of the first Text 1 starting from the specified Index in Text 2. (Specify a substring for the FIND() function to return its position.)
Parameter 1	Text 1	The substring you want to find
Parameter 2	Text 2	The text string containing the substring you want to find
Parameter 3	Index	The position specifying where the search starts The Index starts at 1. If omitted, the value is assumed to be 1.
Return Value Type	Numeric

Note:

The FIND() function returns 0 if no matching string is found.

Notes

The first and second parameters can be of any type. The third parameter must be of the numeric type and can be omitted.

Example

Formula	Result
FIND("I","Information")	1
FIND("i","Information")	9
FIND("o","Information",2)	4
FIND("o","Information",12)	0
FIND("o","Information",-1)	Empty

For example, to find the index of the first Basic in the Level_2_Channel_Name field, add a New Calculation Column operator in the Data Transformation node, and input the formula FIND("Basic",Level_2_Channel_Name), as shown in the following figure.

Click Data Preview to view the result column, as shown in the following figure.

3.1-3.png

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

Overview

Notes

Example

Further Reading

附件列表