Find

Finds the position of a specific text within content for the first time. 【stringToFind】is the specific text to find. 【whereToSearch】specifies the content to search within. You can input text parameters or reference fields. 【startFromPosition】optional, specifies the position to start searching from (using a number to indicate the character position). This function can quickly find the position of specific text within a large content. If it returns the number 3, it means the text appears at the 3rd character of the content. If no matching text is found, the result will be 0. It is similar to SEARCH(), but when no match is found, SEARCH() returns an empty value instead of 0.

Input formula

Input formula

Select a formula

Number

Sum

Average

Max

Min

Round

Round Up

Round Down

Ceiling

Floor

Even

Odd

Int

Abs

Sqrt

Mod

Power

Exp

Log

Value

Text

Concatenate

Find

Search

Mid

Replace

Substitute

Len

Left

Right

Lower

Upper

Rept

T

Trim

Encode URL Component

Logic

If

Switch

True

False

And

Or

Xor

Blank

Error

Is Error

Not

Date

Today

Now

To Now

From Now

Date Add

Datetime Diff

Workday

Workday Diff

Is After

Is Before

Is Same

Datetime Format

Datetime Parse

Datestr

Timestr

Year

Month

Weekday

Weeknum

Day

Hour

Minute

Second

Set Locale

Set Timezone

Created Time

Last Modified Time

Array

Array Compact

Array Unique

Array Join

Array Flatten

Count

CountA

CountIf

CountAll

Object

Record ID

FIND

Finds the position of a specific text within content for the first time. 【stringToFind】is the specific text to find. 【whereToSearch】specifies the content to search within. You can input text parameters or reference fields. 【startFromPosition】optional, specifies the position to start searching from (using a number to indicate the character position). This function can quickly find the position of specific text within a large content. If it returns the number 3, it means the text appears at the 3rd character of the content. If no matching text is found, the result will be 0. It is similar to SEARCH(), but when no match is found, SEARCH() returns an empty value instead of 0.

Usage

FIND(find_text, within_text, [start_num])

Example

FIND("apple", "This is an apple")
=> 12