Search a field, find a particular string, and replace with desired string. For use only on text fields.
StringReplace(StringValue, "Find", "Replacement")
Example: Could be used to remove "Delete***" from an Account Name.
StringReplace({name}, "Delete***", "")
- Input: Delete***Jackson Manufacturing
- Result: Jackson Manufacturing
Example: StringReplace({name}, "ctr", "Center")
- Input: Ctr for Disease Control
- Result: Center for Disease Control
Note: WILL REPLACE the "find" value ANYWHERE it finds it in the name.
Be sure to use the proper function and include punctuation and spaces as needed. Review results carefully before processing. For example: StringReplace({name}, "Dr", "") will change "Dr. Michael Andrew" to ". Michael Anew".
Click HERE to return to the full list of MassImpact Formulas.
