How to Extract Text with an Airtable Formula

Take our free Airtable Crash Course!
https://garethpronovost.com/airtable-...

Getting Stuck? See how we can help!
https://garethpronovost.com

Get our Airtable Field Type download!
https://www.gapconsulting.io/airtable...

_________________________________________


Table of Contents:

00:00 - Intro
01:05 - Outline the Problem
01:46 - How to find the Image URL
03:22 - Setting up the MID Formula
05:45 - Solving for the Starting Point
08:37 - Solving for the Length

_________________________________________


Software Resources (may contain affiliate links):

Airtable - https://airtable.com/invite/r/v0eI3ASY

_________________________________________


Within an Airtable database, it's common to need to extract or "pull" text from a long string. There are many reasons you may want this, ranging from social media posts to contract creation. Luckily, the methodology for extracting the desired text is always the same: reference the string, find out where to start, and find a length of characters to extract.

Now sometimes, your starting position and length will be constant. If so, then this is a much easier formula to write! But, in the majority of cases, you'll want a dynamic variable for your starting position and length. In these cases, a more robust formula is required.

In this video, I walk through the two formulas that we will need to use in tandem to produce a dynamic output. Check it out and follow along in your own database to perfect your formula skills!

_________________________________________


Learn more at these links: 🔗 👇

Join us for our next live training!
https://www.garethpronovost.com/webin...

Take our free Airtable Crash Course!
https://garethpronovost.com/airtable-...

Getting Stuck? See how we can help!
https://garethpronovost.com

Get our Airtable Field Type download!
https://www.gapconsulting.io/airtable...

#AutomateYourLife #GarethPronovost #Airtable