Can't believe no SPLIT formula exists on Airtable

[UWS_services]

Hello,

I have been searching a quite universally used feature like split text to columns, which is something we are quite used to do.

Should be as easy as: SPLIT function - Docs Editors Help

Of course it might need indicating destination fields, but that’s all…

Possible response: “We don’t know how many output columns there might be”-> just limit it to the number of output columns specified within the formula.

If I set only 2 output columns, then too bad if a field had 3 strings, only 2 will get out of it.

Instead, I have only found this “solution” around here:

Split text in 1 column into 3 separate columns Formulas

I’m guessing that there are line breaks after “Department” and “9701,” which we can use to create formulas to extract the pieces. First, create a formula field that contains the following: SUBSTITUTE({Credit Bureau}, "\n", REPT(" ", 50)) This will replace all line breaks with large blocks of spaces (50 characters each in this case). I’ll name this field {Spread}, but you can use any name you prefer as long as you use that name in the later formulas. (It won’t look any different from the origin…

I mean, WoW we are spliting a field to to columns, not sending a rocket to mars…

In this specific case everything needed would be the SPLIT formula using the break line as separator and the 3 destination fields. And voilà, done.

So guys, would really appreciate that you contact the right department and ping them about giving the SPLIT formula a try. I think many people around will appreciate it.

My current workaround: Copy to google sheets the column, SPLIT, paste back to Airtable.

Yeah, I know, I bit embarrasing, that’s why I opened the topic.

Thanks,