ReplaceList()

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.