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)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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 (0)

Report

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 (0)

Report

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 (0)

Report

Sorry, don't know regex, lol.

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report

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 (0)

Report

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 (0)

Report

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 (0)

Report

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

Was this reply helpful? Yes No
Verified answer

yoko2020 495 on at

Like (1)

Report
@UK_Mike

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

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report

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

Was this reply helpful? Yes No