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