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”.