Substitutes a specific part of a string with another string.

Syntax

substitute ( text, find, replace_with )

text: (Text) The string to be modified.

find: (Text) The part of the string that will be replaced.

replace_with: (Text) The replacement substring.

Returns

Text

Examples

You can experiment with this function in the test box below.

Test Input

substitute("hello world","hello","my")

TEST

substitute("hello world","hello","my") returns my world