Description
The SEARCH function finds the position of a specified substring within a text string, starting the search at a specified position. This function is not case-sensitive.
Usage
This function is used to locate the position of text within a string, optionally starting the search at a specific position.
Syntax:SEARCH(find_text, within_text, [start_number])
Examples
-
Search Text from a Specific Position in a String:
SEARCH(LATEST(#[Actions].[Description]), "Example text to search", 3)Searches for the text in the Description field of the latest Actions record within the string
"Example text to search", starting from the 3rd character. -
Search for Text within a Field:
SEARCH(#[Text], LATEST(#[Actions].[Description]), 4)Searches for the text in the Text field within the Description field of the latest Actions record, starting from the 4th character.
-
Dynamic Starting Position Based on Another Field:
SEARCH(#[Text], "Example text to search", LATEST(#[Actions].[Number]))Searches for the text in the Text field within the string
"Example text to search", starting from the position specified by the Number field of the latest Actions record. -
Search Using a Calculation as Starting Position:
SEARCH(#[Text], "Example text to search", #[Calculation])Searches for the text in the Text field within the string
"Example text to search", starting from the position specified by the result of the Calculation attribute.
Inputs
| Argument | Data Type | Description |
|---|---|---|
| find_text | Text | The text string to find. |
| within_text | Text | The text string in which to search. |
| [start_number] | Number | (Optional) The position in within_text from which to start the search. Default is 1. |
Returns
Type: Number
- Produces the position of the substring within the specified text string, or returns an error if the substring is not found.