Replace
Last updated
Was this helpful?
Last updated
Was this helpful?
The Replace function searches through a input string for a substring and replaces every instance of it with a replacement string.
This is useful for standardizing alternative abbreviations and names, fixing common misspellings, changing one delimiter for another, and selectively removing particular substrings.
string (required)- String to be searched and modified.
substring (required)- Substring to be found and replaced.
replacement (required)- String to replace the substring.
Returns: "San Francisco County"
Replace("File Name"," ","")
Returns: "FileName"
Using an empty string as your replacement string allows you to remove every instance of the substring
When applied to the [Order Replaced] column, returns:
