User Tools

Site Tools


syntax:functions:find

Find(text, look_for)

Category: Text function


Description

This function finds the exact position of look_for within text and returns the position of the first character. If look_for is not found within text then it returns 0.

The first character in text has an index of 1.


Arguments

ArgumentTypeDescription
textTextThe text value to search within for the look_for string.
look_forTextThe text string to search for within text.

Return value type: Number


Remarks

This function is case sensitive.

Both arguments are implicitly converted to text values if required.


Examples

find('New York', 'York') //Returns 5
find('New York', 'New') //Returns 1
find('New York', 'Dallas') //Returns 0
find('New York New York', 'York') //Returns 5  (Returns the position of the first instance only)
find('New York', 'new') //Returns 0  (Unmatched due to case)
find([City], 'Ant') //Returns 5  (Using a field name; [City] = 'San Antonio')
find(1200, 2) //Returns 2  (Numeric values are converted to text implicitly)


See also

syntax/functions/find.txt · Last modified: 2021/08/14 22:04 by craigt