Return only the Email Address String using RegEx Replace

[taxguy33]

Hello,

I am struggling to complete this RegEx Replace expression in a Formula tool. I need the inverse to be returned compared to what is happening right now.

Currently, my string is something like "href=\"mailto:Bob.Smith@abc.com\"><span"

I'm using a RegEx Replace formula that says:

REGEX_replace([Body], "\w+.\w+@abc.com", "") 

and only "href=\"mailto:\"><span" is the result of the formula.

I want the exact inverse of that result - Bob.Smith@abc.com to be the only result. 

Can someone please provide guidance on how I invert this formula to produce my desired results?

Thanks!

[christine_assaad · Accepted solution]

Hi @taxguy33 

Is the below what you are looking for? Cheers!

[Qiu]

@taxguy33 
Considered some more general cases.