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”