Searching for an email address within a text field

[George_Fischetti]

Hi Folks - I'm searching for an email address that is embedded within a free form text field.   I have created a Regex expression but I'm only getting the first part of the address, everything after the the @ symbol doesn't appear.

Example:

This is some sample text that has my email gfisch13@msn.com and I'm only getting the gfisch13 part.

This is my expression:  (\<\w+\>)@.*

I'm new to RegEx and know I'm missing something, I just don't know what.

Appreciate any help!

[atcodedog05]

Hi @George_Fischetti 

Here is how you can do it.

Workflow:

Hope this helps : )

[George_Fischetti]

@atcodedog05 I was way off, wow.   While this seems to work I am getting regular text for records where no email address exists.  Is there a way to eliminate that, If no email is present I'd rather see a blank field.

[atcodedog05 · Accepted solution]

Hi @George_Fischetti 

Here is the updated workflow

Hope this helps : )

[George_Fischetti]

@atcodedog05 this is perfect, can't thank you enough for the guidance!!

[atcodedog05]

Happy to help : ) @George_Fischetti 

Cheers and have a nice day!