Regex Email Domain Name Only

(0) Share

Report

Posted on by UK_Mike

Hi All,

Looking to extract just the domain name, no suffix.

Below regex works perfect, except for .co.uk , or any other with more than one " . " 🙄

(?<=@).*(?=\.)

info@Amazon.co.uk
info@Amazon.com
sales@Amazon.com
info.more@Ebay.com
info@ebay.co.uk
info@Ebay.com
sales@ebay.com
info.more@Ebay.de
info.more@Ebay.cn
info.more@Ebay.ke
info.more@Ebay.ie

Many thanks 😁

Categories:

Power Automate Desktop

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Pstork1 69,567 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Wouldn't it be easier and more reliable just to use the Text Split() function on the '@',which will create a list of two elements and then remove the first element by index. That would leave you with the domain in all cases since addresses are only allowed to use the @ once.

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, maybe I should have explained a bit further, im in testing mode, will try split text another time...

Thanks 😁

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I'm with @PSTR.

For each %CurrentItem% in List %Emails%
Parse Text on %CurrentItem% finding the "@" symbol. This will give you the position just before "@" (0 based index).
Get Subtext starting at Position to the end of the text.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, don't know regex, lol.

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

Me neither !!! 😂
Well a bit I suppose....

More than one way to skin a cat etc, just trying this way first is all.
Thanks guys 😁

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Google is friend:

https://stackoverflow.com/questions/39027204/regex-get-domain-name-from-email

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

Nope.................... 😂
Nice try though...
I can get what I want provided theres only one " . " after the domain name...

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

This the best I can get.......

Was this reply helpful? Yes No
Verified answer

yoko2020 495 on at

Like
a
(1)

Report
Copy link

Link copied!
@UK_Mike

Try this
(?<=@).+?(?=\.)

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

Perfectoooooooooooooooo 😀
Cheers man, jeez I was close, that bit in the middle 🙄

Was this reply helpful? Yes No