REGEX_MATCH_AND_REPLACE Function

Parameters: (String, String, String, Boolean)

Returns: String

Replaces matches in a regular expression with a given string.

• The first parameter is the source string. It can be NULL.
• The second parameter is the regular expression. If it has invalid syntax, the On Error action will be followed.
• The third parameter is the replacement string. It can be NULL.
• The fourth parameter is a boolean (true/false) flag indicating if ALL matches should be replaced (TRUE) or only the first match (FALSE).

Example:
        REGEX_MATCH_AND_REPLACE('This is my "cat". No, this is my dog!','cat|dog','mouse',TRUE)

Result: This is my mouse, No, this is my mouse!