arraydeduplicate(
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

- array( --
- arrayelement( --
- arrayrange( --
- arrayreverse( --
- arraysearch( --
- arraysort( --
- extract( --
- Text Arrays -- A numbered collection of text values.

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.