Savant

<code>text</code>: The input text string in which you want to perform replacements.

<code>search</code>: The text you want to find and replace.

<code>replace</code>: The text with which you want to replace the found search string.

1. <code>text</code>: The input text string in which you want to perform replacements.
2. <code>search</code>: The text you want to find and replace.
3. <code>replace</code>: The text with which you want to replace the found search string.

The <code>REPLACE()</code> function is case-sensitive, meaning it will only replace text that exactly matches the specified search string in terms of both character sequence and letter case. If you need case-insensitive replacement, you may consider using <code>REGEX_REPLACE()</code> to achieve the desired result.

Replaces all occurrences of a specified search string with a replacement string

REPLACE

Savant App

Savant Help

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you

Description	The `REPLACE()` function is used to replace all occurrences of a specified search string with a replacement string within a given text. It's a versatile tool for text manipulation and data cleaning.
Syntax	REPLACE(`text`, `search`, `replace`)
Output	text

ID	Text	REPLACE
1	Huge SALE on electronics today!	Huge DISCOUNT on electronics today!
2	Special SALE: Save 20% on select items.	Special DISCOUNT: Save 20% on select items.
3	No SALE available for this product. SALE	No DISCOUNT available for this product. DISCOUNT

Variables

Example