Module: Editor
Version: 2.2.1 +
Description
The formula 'Replace' replaces old values in a matrix for new values. Only the values that equals the search value will be changed. The other values remain the same.
Parameters
Matrix:
This is the matrix of type long, double, string or date where the formula 'Replace' will be used.
Old_Value:
This is the search value.
New_Value:
This is the value that replaces the Old_Value.
Example
Description
In the following example you will see a DataTable where the function ‘ Replace’ is used. In the first matrix you see a number of values. Beneath the matrix you see the text: Old_Value: and New_Value. This means that in the matrix the old value will be replaced by the new value as you can see in the result matrix.
Values parameters
Input:
| Index | Column 0 | Column 1 | Column 2 |
|---|
| 0 |
2 |
0 |
0 |
| 1 |
0 |
2 |
0 |
| 2 |
0 |
0 |
2 |
Old_Value:
2
Result
Output:
| Index | Column 0 | Column 1 | Column 2 |
|---|
| 0 |
8 |
0 |
0 |
| 1 |
0 |
8 |
0 |
| 2 |
0 |
0 |
8 |