--- title: "Use the FIND Function to Identify the First Occurrence of Text" slug: "find-function" description: "Learn to apply the FIND function to identify the first occurrence of a string inside another string in Pigment. Returns position or BLANK." tags: ["FIND ", "formula syntax", "functions ", "Modeling and Formulas", "Pigment Blocks", "Pigment Boards"] updated: 2025-05-30T09:42:15Z published: 2025-08-22T10:57:28Z --- > ## Documentation Index > Fetch the complete documentation index at: https://kb.pigment.com/llms.txt > Use this file to discover all available pages before exploring further. # FIND function ## ​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)` | `BLANK` | 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](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628) Related articles: [MID](/v1/docs/mid-function), [CONTAINS](/v1/docs/contains-function), [STARTSWITH](/v1/docs/startswith-function), [ENDSWITH](/v1/docs/endswith-function) > [!TIP] > 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!