Extrat server address Email

azerty64

Hello,

I cannot extract the server address from an email address. Can you help me ?

Ex : xxxx.xxxx@grdf-txt.com

I want to extract "grdf-txt"

My formula : =UPPER(MID(LEFT(Email@row; FIND("."; Email@row) - 1); FIND("@"; Email@row) + 1; LEN(Email@row)))

This formula works but only for the following format xxxxxx@grdf-txt.com

Thank you

Cordialy,

azerty64

Find more posts tagged with

Accepted answers

Mike TV

@azerty64

Here's another version which deals with both .com and .org email addresses in case someone has a .org email address:

=IFERROR(MID(email@row, FIND("@", email@row) + 1, FIND(".com", email@row) - FIND("@", email@row) - 1), MID(email@row, FIND("@", email@row) + 1, FIND(".org", email@row) - FIND("@", email@row) - 1))

All comments

Mike TV

@azerty64

=MID(email@row, FIND("@", email@row) + 1, FIND(".com", email@row) - FIND("@", email@row) - 1)

Mike TV

@azerty64

Here's another version which deals with both .com and .org email addresses in case someone has a .org email address:

=IFERROR(MID(email@row, FIND("@", email@row) + 1, FIND(".com", email@row) - FIND("@", email@row) - 1), MID(email@row, FIND("@", email@row) + 1, FIND(".org", email@row) - FIND("@", email@row) - 1))

azerty64

https://community.smartsheet.com/discussion/comment/349222#Comment_349222

Hello @Mike TV ,

Thank's it's perfect.

Have a nice day !!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.