syntax:functions:find
This is an old revision of the document!
Table of Contents
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
Argument | Type | Description |
---|---|---|
text | Text | The text value to search within for the look_for string. |
look_for | Text | The 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') = 5 find('New York', 'New') = 1 find('New York', 'Dallas') = 0 find('New York New York', 'York') = 5 //Returns the position of the first instance only find('New York', 'new') = 0 //Unmatched due to case find([City], 'Ant') = 5 //Using a field name; [City] = 'San Antonio' find(1200, 2) = 2 //Numeric values are converted to text implicitly
See also
syntax/functions/find.1627877599.txt.gz · Last modified: 2021/08/02 00:13 by craigt