Loading
Feature degradation | Gmail Email delivery failureRead More
Extend Salesforce with Clicks, Not Code
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            FIND

            You are here:

            1. Salesforce Help
            2. Docs
            3. Extend Salesforce with Clicks, Not Code

            FIND

            Returns the position of a string within a string of text represented as a number.

            Use

            FIND(search_text, text[, start_num]) and replace search_text with the string you want to find, replace text with the field or expression you want to search, and replace start_num with the number of the character from which to start searching from left to right.

            Tips

            • Be sure to remove the brackets, [ and ], from your formula before validating it.
            • If the field referenced in your text parameter is blank, the formula field displays 0.
            • Your search_text parameter is case-sensitive and can't contain any wildcard characters.
            • If your search doesn't return any results, a 0 displays in the field.
            • The start_num parameter is optional. If you don't enter a start_num value, the formula uses the value one, or the first character in the string.
            • If your start_num isn't greater than zero, a 0 displays in the field.
            • If your start_num is greater than the length of the text, a 0 displays in the field.
            • When entering your start_num parameter, remember that some fields like the Website field are unique because a http:// is automatically appended to the beginning of the text you enter.
            • The first character in a string is designated as one rather than zero.
            Street Address Example
            Street Address Example

            FIND(" ", Street) returns the character position of the first space in the Street field. You can use this number to find out the length of the street address as a means of separating a street address from a street name in an address field.

            Deriving Website Addresses Example
            Deriving Website Addresses Example

            SUBSTITUTE(Email, LEFT(Email, FIND("@", Email)), "www.") finds the location of the @ sign in a person's email address to determine the length of text to replace with a “www.” as a means of deriving their website address.

             
            Loading
            Salesforce Help | Article