Re: Split text to multiple columns
Like this?
It looks like you have seven values that are separated by double slashes.
Unfortunately, Airtable formulas do not have a SPLIT() function, so we have to look elsewhere.
There are actually lots of formulas that can work, but using a single regular expression pattern that works for all seven formulas makes things easier to maintain.
To get subsequent values, just change the number in the fourth line.
The difficulty that I have with situations like this is there is only one example, and it isn't clear whether or not all the other values will follow the same pattern or not. In this case, it looks like seven values separated by double slashes. However, if other values will have different patterns, such as more/fewer values, that can affect the formula.
It is possible to calculate the number of values based on the number of slashes.
Then the number of values can be used to build the regular expression. Here is an example.
On the other hand, you may have some other variations that will cause other problems.
Another possibility is to use AI to extract the values for you.
I also wonder if you are coming from a spreadsheet background and if something different might actually be better for whatever your ultimate end goals are.
