Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Extractic the very last email from a field

Topic Labels: Formulas
157 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello there,
I am trying to extract the very last email that is input into a field.
Example of data would be:

godzilla@gmail.com, mouse@gmail.com, waterbottle@gmail.com

I want to grab the very last email no matter how many emails are input in the field. I have tried using a combination of RIGHT() and MID() but so far haven’t been successful.

Thank you all in advance!!!

2 Replies 2

Hi @Alex_Lawson
Can you try this?

LEFT(
    ARRAYJOIN(
        {Emails}
        )&',',
    FIND(
        ',',
        {Emails}&','
        )-1
    )

Hi @Vivid-Squid
Thanks a lot for the reply!

I tried it but it only grabs the first email. Also tried it using RIGHT() instead and it kind of worked.

These are the email examples I used:
godzilla@gmail.com, mouse@gmail.com, waterbottle@gmail.com, phone@gmail.com, milo@gmail.com

And this was the ouput:
m, milo@gmail.com,