I am trying to pull an email address from a text string in the standard "Description" field on Case object.
The below formula is correctly pulling everything AFTER the "@" symbol in the email address, (for example "@sample.com").I cannot get it to pull the first part of the email address.
Here is the formula I am using
SUBSTITUTE( Description ,RIGHT(Description, FIND("@",Description))+ LEFT(Description, FIND("@",Description)), NULL)
Any advice is appreciated.
Best Answer
You cannot do this via a formula field. You will have to do it with a trigger.
I tried to get this working with just Pattern and Matcher but was having issues. You can use this (it's pretty inefficient but it works)