The arraydeduplicate( function removes duplicate elements from a text array (see Text Arrays).
Parameters
This function has two parameters:text – text array to be de-duplicated.
separator – the separator character or characters for this array.
Description
This statement removes duplicate elements from an array (see Text Arrays). As a side effect it also sorts the array into alphabetical order.
arraydeduplicate("Blue,Red,Green,Red,Green,Blue,Blue",",") ☞ Blue,Green,Red
arraydeduplicate("Jack Mark Alan Greg Mark Bill Greg"," ") ☞ Alan Bill Greg Jack Mark
arraydeduplicate("UPS/UPS/USPS/Fedex/UPS/UPS/UPS",",") ☞ Fedex/UPS/USPS
Error Messages
arraydeduplicate( function: ARRAY parameter must be text. – The array (first parameter) must be text, not a number.
arraydeduplicate( function: SEPARATOR parameter must be text. – The separator character (second parameter) must be text, not a number.
See Also
History
Version | Status | Notes |
10.0 | Updated | Carried over from Panorama 6.0, however, this is now a native function instead of being implemented with the call( function. More than one character is now allowed for use as the separator parameter. |