VALUE_MATCH_REPLACE Function

Parameters: (String, String, String);

Returns: String;

Function to replace all instances of set of character sequences with another sequence in a source string.

The first parameter is the source string.

The second parameter is the csv list of one or more character sequences to be found and replaced.

The third parameter is the csv list of one or more character sequences to be used in replacement.

The second and third parameters must have the same number of entries or an error will occur. Instances of the first value in the search list will be replaced with the first value in the replace list and so on for all value pairs.

Empty string search values are ignored.

Example: 

VALUE_MATCH_REPLACE('The cat flew over the hill’, ‘"cat", “hill", “over"', ‘"dog", "river","into"')

Result: 'The dog flew into the river'