Replace

Finds the specified substring(s) and replaces it with the new text

Replace("The River", "i", "o") → "The Rover"
Replace("Netherland", "Ne", "Mo") → "Motherland"

Inputs

Replace(string, search, replacewith, [isCaseSensitive], [allMatches])

  • string - A text value to search in

  • search - Text to search for

  • replaceWith - Text to replace with

  • [isCaseSensitive] - [optional: true by default**]** - Set false if search should be case insensitive

  • [allMatches] - [optional: true by default**]** - Set false if only the first match should be replaced