replace

Replaces characters in string with new_text, starting at position start and counting length characters. Counting starts from one (1) (not zero (0)).

Always counts in the natural direction based on the selected advertiser's locale. For example, if the advertiser's language is English, this function counts from right to left.

Note: This function is only available in Templates and can't be used in reporting.

Syntax

replace(string, start, length, new_text)

Parameters

string and new_text can be any of the following:

• Static text, such as 'GDN'.
• A Search Ads 360 variable that uses a text format, such as Keyword, Campaign and so on.
• An expression or formula column that returns a text value.

start and length can be any of the following:

• A positive constant, such as 5.
• A Search Ads 360 variable that is a positive number.
• An expression or formula column that returns a positive number.

Examples

• [replace("Hello World", 7, 5, "Sylvester")] returns "Hello Sylvester".

• [replace("Hello World", 6, 6, "")] returns "Hello".

Related links

• Use functions in custom columns
• right
• left
• substitute
• upper
• lower
• length
• mid
• concat
• substitute_all