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