Hey AT Community!
Is there a way to remove the tail ends from formulas in bulk?
Example-
I have 3 urls in 3 different rows:
https://google.com/index?test
https://yahoo.com/example?test
https://apple.com/ending?test
Using a formula (or something els...
Hey Airtable community!
I’ve got a quite large data set that is not very pretty. I need to process it so that I can make use of the data in a real way.
The key issue I am looking to solve is that I need to:
Break apart long data fields into individua...
@Bill.French Interesting, thanks for sharing!
This formula is giving me everything after the 3rd “/”. What I’m looking for is essentially the opposite, everything before (can include) the 3rd “/”.
Justin_Barrett:
IF({URL}, REGEX_REPLACE({URL}, "[^/]*$", ""))
@Justin_Barrett Thanks so much! This is definitely heading in the right direction. This works really great for most of my links.
I should have been more clear, because I have a bunc...
This is working great for about half my columns, thanks Scott!
One follow up question:
I have some data that is formatted slightly differently, example:
[“Data & Analytics Consulting Competency”,“Machine Learning Consulting Competency”,“DevOps Consul...