Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 04, 2022 03:02 AM
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?
Jan 04, 2022 03:16 AM
This post may help you:
Jan 04, 2022 07:10 PM
Hi,
SUBSTITUTE( field ,’,’,’ &’,LEN(field
)-LEN(SUBSTITUTE( field ,’,’,’’)))