Help

Workaround for no SPLIT in Airtable

Topic Labels: Formulas
597 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthew_Comer
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve seen some complain that there is no SPLIT function in Airtable. Here’s my workaround:

I’m dumping data into an existing table and I have formula fields that “pull data out” into other cells based on keywords. The formulas are just combinations of FIND, MID, and LEN. I’m doing this work once and the table will do the work for me when I import new data. Yes, a “split” would be nice, but it’s definitely possible without it. P.S. Don’t forget to escape characters with “\” in formulas.

1 Reply 1
Matthew_Comer
5 - Automation Enthusiast
5 - Automation Enthusiast

Oh and SUBSTITUTE helps.