arrayunpropagate(
ARRAY
,
SEPARATOR
)

The arrayunpropagate( function scans an array from top to bottom, removing duplicate values in a row.


Parameters

This function has two parameters:

array – Original array.

separator – Separator character.


Description

This function scans an array from top to button. If there are two or more duplicate values in a row all but the first will be blanked out. This is similar to the Unpropagate statement, but for an array instead of a database field.

arrayunpropagate("red,green,green,blue,blue,gold,silver",",") ☞ red,green,,blue,,gold,silver

You can use the arraystrip( function to remove the empty values.

The arrayunpropagate( does not sort the array before hand so you may want to use arraysort( before using arrayunpropagate( as in this example.

arrayunpropagate(arraysort("red,green,gold,blue,green,blue,silver",","),",")
    ☞ blue,,gold,green,,red,silver

See Also


History

VersionStatusNotes
10.0No Change/Updated/NewCarried over from Panorama 6.0