Function EN Version 1.90

@Unique

Float IDList List Misc NUMBER Text TimeDate

Syntax

@Unique(TEXT1);

@Unique(FLOAT1);

@Unique(TEXTLIST1);

@Unique(FLOATLIST1);

@Unique(IDLIST1);

Description

Eliminates duplicate entries from TEXTLIST/FLOATLIST/IDLIST TEXTLIST1/FLOATLIST1/IDLIST1 and returns this cleaned-up list.
For TEXT/FLOAT TEXT1/FLOAT1, this value is returned unchanged. For IDLIST, the list must first be sorted with @SortList; otherwise the function will not be executed correctly.

Example: @Unique(TEXT1)

TEXT1:="Hallo Welt !!!";
@Unique(TEXT1);

returns "Hallo Welt !!!"

Example: @Unique(FLOAT1)

FLOAT1:=10;
@Unique(FLOAT1);

returns 10

Example: @Unique(TEXTLIST1)

TEXTLIST1:="New York":"Rio":"Tokio":"Rio":"New York":"New York":"Tokio";
@Unique(TEXTLIST1);

returns "New York":"Rio":"Tokio"

Example: @Unique(FLOATLIST1)

FLOATLIST1:=10:12:15:12:14:15:18:10:12;
@Unique(FLOATLIST1);

returns 10:12:15:14:18

Example: @Unique(IDLIST1)

IDLIST1:=@IDList:10:12:15:12:14:15:18:10:12;
IDLIST1:=@SortList(IDLIST1);
@Unique(IDLIST1);

returns die IDLIST für 10:12:14:15:18

Note : This text was machine-translated and may contain inaccuracies.