Skip to main content

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!

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!

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!


Brilliant Jason! I cant thank you enough!


Glad I could help Carlos!

Reply


Terms & Conditions