UniqueValues
Returns unique values that are in a list based on the specified data type and locale.
Format
UniqueValues ( values {; datatype ; locale } )
Parameters
values - any text expression or field that’s a list of values separated by carriage returns.
datatype - a number that specifies the type of data in values (see below).
locale - the name of the locale of the data in values (see below).
Parameters in braces { } are optional.
Data type returned
text
Originated in version
16.0
Description
For a description of a list of values, see ValueCount function.
Each returned value ends with a carriage return, allowing lists to be easily concatenated.
- The
datatypeandlocaleparameters work the same as those of the SortValues function, except that they affect only how this function determines uniqueness; the data is not sorted. Uniqueness is determined in the same manner as for indexing. See Choosing a language for indexing or sorting.
Notes
- If you set the
localeparameter toUnicode_Raw, this function will distinguish between values based on their Unicode numeric encoding, which for example, differentiates between characters with different case and diacritical marks.
Example 1
UniqueValues ( "34¶600¶18¶600¶18.0" ; 2 ) returns 34¶600¶18¶.
Example 2
UniqueValues ( Product::Colors ) removes duplicates based on the default data type of text in a file in which the locale is English:
RED¶green¶yellow¶
when the Product::Colors field contains RED¶green¶red¶yellow¶.