Extract Email and Website from String

[tjamal1]

Hello, 

I am trying to extract email and website from string if exist any into two separate columns 

I am stuck on Regex Replace function .

Is there anyway to extract email and website from string 

I have attached my packaged workflow 

[patrick_mcauliffe]

You're about 99% of the way there.

Just some slight modifications to the matching regex you used, then put it in the Regex tool with the Parse setting and you'll be there.  

It just needs to include more characters at the start of the string:

Once you've got the full email address, I'd use a formula tool with replace(body,email,'') and then re-run a Regex extract for the website.

[tjamal1]

Thanks for reply ,

can you share your workflow please?

[patrick_mcauliffe]

Sure.  Here you go.

Also, take a look at how the CSV input is modified here.  The default settings you had were truncating that field.

[tjamal1]

Thanks for the workflow 

I tried that but i observed that i am getting incomplete emails 

like  instead of this mostafa24966@hotmail.com  i am getting this6@hotmail.com

Can you help me to resolve this issue?

[patrick_mcauliffe · Accepted solution]

Remove .* in front of your regex expression.