Skip to main content

Replace

This formula allows you to replace a particular substring occurrence inside another string with a given replacement.

JSON Format

{
"type": "replace",
"string": ...,
"occurrence": ...,
"replace": ...
}

Fields

FieldTypeRequiredDescription
stringStatFormulaComponentThe formula for the string where the replacements should be made
occurrenceStatFormulaComponentThe formula for the substring occurrence you want to replace. The Replace formula will replace all occurrences of this substring in the original string.
replaceStatFormulaComponentThe formula for the string that the occurrences should be replaced for.