The REPLACE function in Infoveave replaces a specified number of characters in a text string with another text string, starting from a specified position.
Applicable to
Calculated Columns
Return Value
The REPLACE function returns a new text string where characters starting from the start position in the text are replaced with the replace text string.
If chars are greater than the remaining characters in text starting from start, the function replaces all remaining characters.
Remark
The REPLACE function is case-sensitive.
If start is greater than the total length of text, the replaced word will be added to the end of the text.
If char is greater than the length of text, the whole text will be replaced by the replace text.
If char is 0, the replace word will be added to the text at the defined position.
The REPLACE function replaces NULL with the replace text.
Syntax
REPLACE(<expression>,start, chars, replace)
REPLACE in Calculated Columns
Parameter
Description
Expression
A placeholder in a function that is replaced with the actual column name.
Column Name
The name of the column in the dataset or Datasource that contains the values you want to analyze.
Start
The starting position from which to replace characters.
Char
The number of characters to replace.
Replace
The text string that will replace the specified number of characters starting from the start position in the text.
Steps to Use
Write the REPLACE function. For instance REPLACE(<expression>,start, chars, replace)
Replace the Column Name with the actual name of your column required.
To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.
Example
You can use the REPLACE function to replace the first two characters of the text from the [COUNTRY] column with “IN”, as
