replace

Replaces all occurrences of "string_expression2" in "string_expression1" with "string_expression3". If "string_expression3" is not specified, then it removes all occurrences of "string_expression2".

Syntax

replace ( string_expression1 , string_expression2 [ ,
 string_expression3 ] )