replace#

Description#

Replaces all instances of the substring in the input string with a provided value.

Return type#

string

Domain#

This is a scalar function (calculates a single output value for a single input row.)

Categories#

Usage#

replace(value, substring, replacement)

Argument

Type

Optional

Repeatable

Restrictions

value

string

no

no

none

substring

string

no

no

none

replacement

string

no

no

none

Examples#

make_col log:replace(log,"127.0.0.1","localhost")

This replaces the string “127.0.0.1” with the string “localhost” in a column named “log”.