Split text to multiple columns

Topic Labels: Data Formulas
287 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to separate the following text in different columns :

Column A : @Ben//test-bug//Feb 22, 2024 3:54pm UTC//Budget//Test again//Test again//Moderate

Column B : @Ben
Column C : test-bug
Column D : Feb 22, 2024 3:54pm UTC
Column E : Budget
Column F : Test again
Column G : Test again
Column H : Moderate

1 Reply 1
18 - Pluto
18 - Pluto

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.