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