Help

Concatenate From a Multiple Selection Column

Topic Labels: Formulas
Solved
Jump to Solution
1226 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlos_Hurtado
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everyone! Ive exhausted all my options. Hopefully the amazing Airtable Community can help me out…

So in essence the formula needs to get words from Column A and separate them with a vertical bar i.e. " | " and if a set of words like “New This Month” exists in column A the spaces need to be replaced by underscores.

In column A (Multiple Select) I have e.g:
Movie, New This Month, Entertainment

I need for column B (Formula) to produce the following with the data in column A e.g:
Movie | New_This_Month | Entertainment

Thank you in advance!
Screen Shot 2020-06-23 at 2.53.17 PM

1 Solution

Accepted Solutions
Jason
Airtable Employee
Airtable Employee

This should do the trick @Carlos_Hurtado.

SUBSTITUTE(SUBSTITUTE({Column A}, " ", "_"), ",_", " | ")

The first substitution replaces any blank spaces with underscores, and the second replaces instances of ,_ (an affect of the first substitution) with vertical pipes. This will work with any number of multiple select options.

Let me know if that helps!

See Solution in Thread

3 Replies 3
Jason
Airtable Employee
Airtable Employee

This should do the trick @Carlos_Hurtado.

SUBSTITUTE(SUBSTITUTE({Column A}, " ", "_"), ",_", " | ")

The first substitution replaces any blank spaces with underscores, and the second replaces instances of ,_ (an affect of the first substitution) with vertical pipes. This will work with any number of multiple select options.

Let me know if that helps!

Brilliant Jason! I cant thank you enough!

Glad I could help Carlos!