Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Remove duplicate in string and/or concatenate words

Topic Labels: Formulas
Solved
Jump to Solution
406 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.