I’m not great with formulas, but I’ve spent hours on google and airtable forums trying to figure out how to do this. Let me see if I can explain this well. I have a string of text and I’m trying to find the first name of the person listed in the text. The text looks something like this:
You have a new reservation.
Customer First Name: John
Customer Last Name: Doe
Customer Phone #: 1234567890
Customer Email: firstname.lastname@example.org
Date: Thursday, December 9, 2021
Service: Package 1
I just want to grab the First name only from the string and I can’t for the life of me figure out how to format the formula.
Any help would be much appreciated!!