Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Separator for multiple formula output in single field

Topic Labels: Formulas
399 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I am writing a large formula that looks for answers in another field and outputs their related categories. I have done this with multiple IF(OR(SEARCH( formulae, and it has worked great.
However, this returns multiple categories as a single string running into each other, eg. “SensoryEscapeTangible”. I need a way to insert a separator between these values without having to create another field. Any suggestions?
PS- ARRAYJOIN( doesn’t work as the use of ‘&’ between the formulae has concatenated the output into a single string already!

Thanks!

1 Reply 1

An easy way would be to put the separator in the text string for each category returned (e.g. “Sensory,”). Then, wrap the entire formula in a function to trim the final separator. Maybe

REGEX_REPLACE(YOURFORMULA,’,$’,’’)

Replace the comma before the dollar sign with the separator that you use. Hope it works for you.