
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 05, 2022 11:50 AM
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!!!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 05, 2022 12:34 PM
Hi @Alex_Lawson
Can you try this?
LEFT(
ARRAYJOIN(
{Emails}
)&',',
FIND(
',',
{Emails}&','
)-1
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 05, 2022 12:54 PM
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,
