Reference > Functions reference > Text functions > UniqueValues
 
UniqueValues
Purpose 
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 
FileMaker Pro 16.0
Description 
Each returned value ends with a carriage return, allowing lists to be easily concatenated. See LeftValues function for more information on working with lists of values.
The datatype and locale parameters 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 locale parameter to Unicode_Raw, this function will distinguish between values based on their Unicode numeric encoding, which for example, differentiates between characters with different case and diactrical marks.
This function is not supported in runtime solutions and returns "?".
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¶.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
SortValues function