Searches a string for a substring, and replaces it.


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.



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