Skip to main content

Want to add another seperator to a row of unique values

  • January 4, 2022
  • 2 replies
  • 24 views

Forum|alt.badge.img

From a look up field a have a row of values which are in my case dog breed subscriptions. I cropt this row by using the Array unique functions so it only shows unique vallues. Some rows have just one unique value of some have for example 3. I want to seperate always the last value in a row with an & or and instead of a comma.

For example

Bernese Mountain Dog, Rhodesian Ridgeback, Labradoodle → Bernese Mountain Dog, Rhodesian Ridgeback & Labradoodle

Rhodesian Ridgeback, Labradoodle → Rhodesian Ridgeback & Labradoodle

Does anyone now a solution for this problem?

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • January 4, 2022

This post may help you:


Alexey_Gusev
Forum|alt.badge.img+25

Hi,

SUBSTITUTE( field ,’,’,’ &’,LEN(field
)-LEN(SUBSTITUTE( field ,’,’,’’)))