Loading
Salesforce now sends email only from verified domains. Read More
CRM Analytics
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
            replace Function

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            replace Function

            Replaces a substring with the specified characters. If any of the arguments are null, then the function returns null. This function is case-sensitive.

            Required Editions

            Available in Salesforce Classic and Lightning Experience.
            Available with CRM Analytics, which is available for an extra cost in Enterprise, Performance, and Unlimited Editions. Also available in Developer Edition.

            Syntax

            replace(string,searchString,replacementString)

            Arguments

            Argument Description
            string Dimension field or text string that contains the substring to be replaced.
            searchString Substring to replace. If searchString is an empty string, the function returns null.
            replacementString The value that replaces the substring.
            Tip
            Tip To replace null values in a dimension or date column, use the Replace transformation and select the Search for null option.
            Example
            Example To change the account name from “salesforce.com” to “Salesforce” in the Account_Name column, use the following formula.
            replace([Account_Name],"salesforce.com","Salesforce")
            Enter the function in the Formula section of the Preview tab.
             
            Loading
            Salesforce Help | Article