Help

Remove duplicate in string and/or concatenate words

Topic Labels: Formulas
Solved
Jump to Solution
1154 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brian_Boyd
5 - Automation Enthusiast
5 - Automation Enthusiast

See the attached screenshot for an idea of what I’m trying to accomplish. I’m using a formula to concatenate the names of sellers and buyers. Simple except that if there are two or more names, how can I remove the identical last name, or add an & between names if they are different names?

image

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

This can be done using a single rollup field. Roll up the last name based on the {Linked to Contacts}, and use this aggregation formula:

IF(values, "Seller to " & ARRAYJOIN(ARRAYUNIQUE(values), " & "))

Screen Shot 2021-09-05 at 9.03.36 AM

The ARRAYUNIQUE() function gets rid of duplicate last names, ARRAYJOIN() joins them with the ampersand, and the rest adds the prefix as long as there’s one incoming name.

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

This can be done using a single rollup field. Roll up the last name based on the {Linked to Contacts}, and use this aggregation formula:

IF(values, "Seller to " & ARRAYJOIN(ARRAYUNIQUE(values), " & "))

Screen Shot 2021-09-05 at 9.03.36 AM

The ARRAYUNIQUE() function gets rid of duplicate last names, ARRAYJOIN() joins them with the ampersand, and the rest adds the prefix as long as there’s one incoming name.

Thank you so very much. This works perfectly.