Workaround for no SPLIT in Airtable

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.