REPLACE_ALL function

REPLACE_ALL function

Function Name	Description	Usage	Input parameter	Return value
REPLACE_ALL	Replaces all the occurrences of a substring in a string.	REPLACE_ALL(value, value)	This function takes the following arguments: First argument: String to match in the existing string. Second argument: The replacement string.	Updated string with the replaced values.

Supported data type

The REPLACE_ALL function supports the following data type:

• String

Example: Replace all the occurrences of a substring with a new value.

Sample data: $var1$ = "HelloApigee"

Usage: $var1$.REPLACE_ALL("Apigee", "Google")

Return the current string "HelloApigee", with any substrings matching "Apigee" replaced with "Google."

Output: HelloGoogle

Recommendation

• Learn how to add and configure a Data Mapping task