Alternate UNIQUE() function; with spaces after commas!


#1

Suggestion: If anyone gets the chance, I would like to be able to see the results that are concatenated using the UNIQUE() function, such that there is a “space” included after the commas.

It would be much clearer, and therefore easier to read!

Thanks,

Kane


#2

Hi,

We will adjust our UNIQUE formula to allow users to define the separator they need. I’ll notify you once it’s online.


#3

Thanks Amy,

That’s great news!

Kane


#4

Hi Kane,

It’s now supported to specify the separator of your UNIQUE() formula result.
You can now use UNIQUE(value, “specified_separator”) to retrieve the value. Please note that the separator cannot be alphanumeric.


#5

Great news!

Thank you very much! I will be making changes to my DB accordingly!

Kane