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
Formula In Use
What's Next?
- Learn more about how to write formulas
- Check out the RSUBSTITUTE operation
- Check out the SEARCH operation
If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...
and please let us know 👇