Extract the username, domain, and extension of an email | REGEX Formulas 85

In this part, we are going to explore:
0:00 REGEX - How to extract the username, domain, and extension of an email?
Feel free to make your copy of this spreadsheet:

#GoogleForEducation #GoogleWorkspace #GoogleSheets

If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded

Useful Link:
Ben Collins (Google Developer Expert & Data Analytics Instructor)

Google Sheets training:

The whole playlist link:

Follow us on Pinterest:

Apple logo

Windows logo

Welcome back, Educators.
Our mission is to extract the extension of these URLs.
The URL extension maybe contain one or two parts and consist of letters (two letters or more).
This pattern returns the letters (lowercase and uppercase) at the end of the string.
But it doesn’t return the extension that contains two parts completely.
This pattern returns the extension that contains two parts correctly.
But what about the extension that has one part?
By grouping these two patterns and using the OR operator, we still have the problem.
By adding the dot before the group, we tell REGEX to start extraction after it.
We add the backslash before the dot because it is one of the special characters.
We still have one possibility that doesn’t return the correct extension.
Add [^www] to the pattern.
The caret symbol inside the square brackets means: is not.
We replace the plus symbols in the pattern with {2,} which means two or more.
Because a valid extension consists of two letters or more.
We could use the LOWER function to convert all the letters to lowercase before applying the pattern.
See you soon in the next part of this lesson.
That’s it, have fun. Thanks for watching.
If you like the video, please give us a thumbs up.
And subscribe to our channel.

[GoogleWorkspaceTutorial]

In this part, we are going to explore:
REGEX - How to extract the username, domain, and extension of an email?
Feel free to make your copy of this spreadsheet:

[safyiaalwadi]

الامدىيسي العبقري الحادق لك دعاءي وجزيل شكري وتقديري لك حق عليه تعلمت منك الكثير يامدريسي

[اماحمدالمحمد-نذ]

ياالله ارحم الراحمين اللهم ارحمنا برحمتك وسلم يداه انه عبقر يالله