arraydeduplicate(
TEXT
,
SEPARATOR
)

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

VersionStatusNotes
10.0UpdatedCarried 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.