topic Re: Searching for an email address within a text field in Alteryx Designer Desktop Discussions

Searching for an email address within a text field

George_Fischetti — Wed, 09 Feb 2022 19:39:18 GMT

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!

Re: Searching for an email address within a text field

atcodedog05 — Wed, 09 Feb 2022 19:43:05 GMT

Hi @George_Fischetti

Here is how you can do it.

Workflow:

Hope this helps : )

Re: Searching for an email address within a text field

George_Fischetti — Wed, 09 Feb 2022 20:10:13 GMT

@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.

Re: Searching for an email address within a text field

atcodedog05 — Wed, 09 Feb 2022 20:14:34 GMT

Hi @George_Fischetti

Here is the updated workflow

Hope this helps : )

Re: Searching for an email address within a text field

George_Fischetti — Wed, 09 Feb 2022 20:21:31 GMT

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

Re: Searching for an email address within a text field

atcodedog05 — Thu, 10 Feb 2022 06:28:27 GMT

Happy to help : ) @George_Fischetti

Cheers and have a nice day!