Replace

Searches a string for a substring, and replaces it.

Usage

Replace(string, substring, replacement)

string (required) String to be searched and modified.

substring (required) String to be found and replaced.

replacement (required) String to replace the indicated substring.

 

Example

Replace(“Kings County”, “ County”, “”)
  • Finds “ County” and replaces it with an empty string, effectively deleting a portion of the original string.
Replace([City], “SF”, “San Francisco”)
  • Searches the Column [City] for “SF” and replaces it with “San Francisco”

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us