Replaces one or more substrings with another string.

The ReplaceList() function has three parameters:

  • sourceString (string): Required. The string to search.
  • replacementString (string): Required. The replacement string.
  • searchString1 (string): Required. The string to find.

You can search for more than one substring by appending additional parameters. You can add as many search strings as necessary.

This example removes delimiting characters (|, ;, and ,) from a string of text. It replaces the delimiters with a string of text that makes the complete list easier to read.

The function returns a string in which the delimiting characters have been replaced with the replacement string.