This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
