Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

ListRemoveDuplicates

Use this function to remove duplicate entries from a list.

Syntax:

ListRemoveDuplicates(list)

where:

  • list is a variable of type NUM[], STRING[], or RANGE that contains the list to remove duplicates from.

Syntax example:

CREATE VARIABLE myList1[] AS STRING

CREATE VARIABLE myList2[] AS STRING

 

SET VARIABLE myList1 = "a|b|c|a|a|d|e|e"

Set VARIABLE myList2 = ListRemoveDuplicates(myList1)

//In this example, myList2 equals a,b,c,d,e.
Published:

ListRemoveDuplicates

Use this function to remove duplicate entries from a list.

Syntax:

ListRemoveDuplicates(list)

where:

  • list is a variable of type NUM[], STRING[], or RANGE that contains the list to remove duplicates from.

Syntax example:

CREATE VARIABLE myList1[] AS STRING

CREATE VARIABLE myList2[] AS STRING

 

SET VARIABLE myList1 = "a|b|c|a|a|d|e|e"

Set VARIABLE myList2 = ListRemoveDuplicates(myList1)

//In this example, myList2 equals a,b,c,d,e.
For an optimal Community experience, Please view on Desktop