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

Workaround for no SPLIT in Airtable

Topic Labels: Formulas
221 0
Showing results for 
Search instead for 
Did you mean: 

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.

0 Replies 0