Description
Finds for the first occurence of a Text within another Text.
If an occurrence is found, returns the position of the first character of the Text to find in the searched Text. If no occurence is found, returns BLANK.
Syntax
FIND(Text to Find, Text to Search [, Starting Position to Search] [, Is Case Sensitive])
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Text to Find (required) | Text | Any Dimensions | Text to find the starting position in the searched Text. |
| Text to Search (required) | Text | No Dimension or Dimensions of Text to Find | Text to search in. |
| Starting Position to Search (optional) | Integer | No Dimension or Dimensions of Text to Find | Position of the character to start the search in, in Text to Search |
| Is Case Sensitive (optional) | Boolean | No Dimension or Dimensions of Text to Find | Whether the search is done with case sensitivity. By default, the search is not case sensitive. |
Returns
| Type | Dimensions |
|---|---|
| Number | Dimensions of Text to Find |
The value returned is the position of the character of the first occurrence found in Text to Search.
BLANK if Text to Find is not present in Text to Search.
BLANK if Starting Position to Search is a negative value or 0.
Examples
| Formula | Result | Description |
|---|---|---|
FIND(“a”, “abc”) | 1 | The Text “a” is the first character of “abc”. The result is 1. |
FIND(“c”, “abc”) | 3 | The Text “c” is the third character of “abc”. The result is 3. |
FIND(“A”, “abc”) | 1 | The search is not case sensitive by default. Finding the Text “A” is equivalent to finding the Text “a”. |
FIND(“A”, “abc", 1, TRUE) |
| The search is case sensitive. “A” is not present in “abc”. |
FIND(“a”, “abc”, 2) | BLANK | The Starting Position to Search is set to 2. The searches the Text “a” from the Text “bc”. |
FIND(“a”, “abc”, 0) | BLANK | The Starting Position to Search, 0, is invalid. |
FIND(“a”, “abc”, -1) | BLANK | The Starting Position to Search, -1, is invalid. |
See also
Excel: FIND
Related articles: MID, CONTAINS, STARTSWITH, ENDSWITH
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
