Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Extractic the very last email from a field

Topic Labels: Formulas
1441 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Lawson
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Vivid-Squid
11 - Venus
11 - Venus

Hi @Alex_Lawson
Can you try this?

LEFT(
    ARRAYJOIN(
        {Emails}
        )&',',
    FIND(
        ',',
        {Emails}&','
        )-1
    )
Alex_Lawson
5 - Automation Enthusiast
5 - Automation Enthusiast

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,