Solved

Concatenate From a Multiple Selection Column

Forum|Forum|5 years ago
June 23, 2020
3 replies
39 views

Carlos_Hurtado
Participating Frequently

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!

Best answer by Jason11

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!

J

+20

Jason11
Inspiring
Answer
Forum|Forum|5 years ago
June 23, 2020

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!

Like

C

Carlos_Hurtado
Author
Participating Frequently
Forum|Forum|5 years ago
June 23, 2020

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!