function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
arjuna Rajput 29arjuna Rajput 29 

Can any one changes in this formula(in fLOWS)

RIGHT({!$Record.Email}, LEN({!$Record.Email}) - FIND("@",{!$Record.Email}))

this formula extract domain name from email
suppose abc@jbl.com
result of this formula is: jbl.com

but ineed jbl only extract from email can anyone help me out to give correct formula
PriyaPriya (Salesforce Developers) 
Hey Arjuna,

Create a formula field named 'Domain' on the Contact object and use the following formula:
  
MID( Email , FIND("@", Email )+1 , FIND(".", Email, FIND("@", Email)) - FIND("@", Email)-1 )



This will extract the domain from the Email field and store it in the Domain field.


Kindly mark it as the best answer if this helps.

Regards,

Priya Ranjan
Maharajan CMaharajan C
Hi Arjuna,

Please try the below formula:
  
LEFT(  SUBSTITUTE({!$Record.Email} , LEFT({!$Record.Email} , FIND("@", {!$Record.Email} )), NULL),FIND(".", {!$Record.Email} , FIND("@", {!$Record.Email}))-FIND("@", {!$Record.Email})-1)

Thanks,
Maharajan.C