Find

Returns the starting position of the first instance of a specific text value within a field value.

Syntax

Find(str, strToFind, startingPosition)

Enabled For

For a description of the business object categories, see Notes on "Enabled For".

Business Object Category Yes/No
Business Rules: Before-Save Rules Yes
Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load) Yes
Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load) Yes
Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load) Yes
Business Rules: Editing Rules Yes
Business Rules: Initialization Rules Yes
Business Rules: Read Only Rules Yes
Business Rules: Required Rules Yes
Business Rules: Validation Rules Yes
Client Expressions Yes
Object Permissions Yes
Services Yes
LDAP Yes
Mobile Yes
Quick Actions (except UI Quick Actions) Yes
UI Quick Actions Yes
Reports Yes
Search/Dashboard without field references Yes
Search/Dashboard with field references Yes

Parameters

Parameter Description
str Text value for which to search.
strToFind Location for the search.
startingPosition (Optional) The position from which to start the search.

Return Value

Number value.

Returns -1 if the text is not found.

If the text is found, returns the starting position (zero-based index) of the first parameter (str) in the second parameter (strToFind).

Example

$(Find("han", Owner))

If the Owner field contains the text "Tom Hanson", this example returns 4.