REPLACE Operation

How to use the REPLACE operation for Computed Attributes

Definition

The REPLACE operation will replace part of a string with a different string.

Example

REPLACE("Pineapple",5,5,"nuts")

Result:
Pinenuts

Syntax Guide

REPLACE(text, position, length, new_text)

text - The text, a part of which will be replaced

position - The position where the replacement will begin (starting from 1)

length - The number of characters in the text to be replaced

new_text - The text which will be inserted into the original text