Find
Returns the starting position of the first instance of a specific text value within a field value.
Searches are not case-sensitive.
Syntax
Copy
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 to be searched for. |
strToFind | Text you want to search in. |
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
Copy
$(Find("printer", Symptom))
If Symptom (Description) contains the text "The printer is broken.", this example returns 4.