replace

replace(source: text, pattern: text, replacement: text) 🡒 text, pure function

Replaces in the source text value all the occurrence of pattern by the replacement value.

Example:

source = "Hello World!"

show table "" a1c2 with
  replace(source, "l", "L")
  replace(source, " ", "___")
  replace(source, " World", "")

See also