ReplaceArray
The ReplaceArray() function is used to replace strings from an array of replacements
Syntax
ReplaceArray (Data Range, Replacement Values)
| Data Range | The range of data used as input |
| Replacement Values | The values in the input to replace, paired with their replacement text. |
Note:
Input parameters can consist of Quintessence functions. This includes functions that return ranges in cases where a parameter value can be a range.
Examples
Example – Replace shortened sector names with their full names
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
Example – Replace shortened sector names with their full names
| Range | Replacement function | |||
| Date | Sector | Weight | =ReplaceArray(A2:C7,A11:B13) | |
| 2018/01/31 | Banking | 26% | ||
| 2018/01/31 | Ind | 21% | ||
| 2018/01/31 | Mining | 45% | ||
| 2018/01/31 | Ins | 30% | ||
| 2018/01/31 | Tel | 50% | ||
| Replacement pairs | ||||
| Ind | Industrial | |||
| Ins | Insurance | |||
| Tel | Telecoms | |||
| Range | Output | |||||
| Date | Sector | Weight | Date | Sector | Weight | |
| 2018/01/31 | Banking | 26% | 2018/01/31 | Banking | 26.00% | |
| 2018/01/31 | Ind | 21% | 2018/01/31 | Industrial | 21.00% | |
| 2018/01/31 | Mining | 45% | 2018/01/31 | Mining | 45.00% | |
| 2018/01/31 | Ins | 30% | 2018/01/31 | Insurance | 30.00% | |
| 2018/01/31 | Tel | 50% | 2018/01/31 | Telecoms | 50.00% | |
| Replacement pairs | ||||||
| Ind | Industrial | |||||
| Ins | Insurance | |||||
| Tel | Telecoms | |||||