Description
Splits a string into an array then returns a percentage indicating how different each element is to the other elements in the array.
Syntax
TextArrayVariance(<input>,<delimiter>)
Arguments
| Argument |
Type |
Description |
Optional |
| input |
Text |
Text containing the array of items to analyse |
No |
| delimiter |
Text – Single Character |
Character used to separate items within the input value |
No |
Returns
Decimal (Percentage)
Examples
| Expression: |
TEXTARRAYVARIANCE("Fred;Bob;Sue;Peter;James", ";") |
| Returns: |
100 |
| Expression: |
TEXTARRAYVARIANCE("Fred;Fred;Sue;Peter;James", ";") |
| Returns: |
90 |
| Expression: |
TEXTARRAYVARIANCE("Fred;Fred;Fred;Peter;James", ";") |
| Returns: |
70 |
| Expression: |
TEXTARRAYVARIANCE("Fred;Fred;Fred;Fred;James", ";") |
| Returns: |
40 |
| Expression: |
TEXTARRAYVARIANCE("Fred;Fred;Fred;Fred;Fred", ";") |
| Returns: |
0 |
Download
Download Example
