John_Krueger1 - profile

John_Krueger1 · Oct 06, 2022

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...

John_Krueger1 · Aug 25, 2022

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...

John_Krueger1 · Oct 07, 2022

You nailed it! Thanks so much @kuovonne. This is exactly what I needed :slightly_smiling_face:

John_Krueger1 · Oct 07, 2022

@kuovonne appreciate the feedback! The data is confidential at this point so I’m unable to share it in bulk.

John_Krueger1 · Oct 07, 2022

@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 “/”.

John_Krueger1 · Oct 07, 2022

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...

John_Krueger1 · Aug 26, 2022

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...

User Statistics

User Activity

Removing the tail end from URLs

Processing data, splitting it into multiple tables, breaking apart cells, and tying it all back together with a reference field

Re: Removing the tail end from URLs

Re: Removing the tail end from URLs

Re: Removing the tail end from URLs

Re: Removing the tail end from URLs

Re: Processing data, splitting it into multiple tables, breaking apart cells, and tying it all back together with a reference field