function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
B2AB2A 

Formula field to separate strings in a Text field??

Hi All,

 

I'm stuck with a problem:

 

I have a text field that has full name Eg. John Smith (and no we cannot use a lookup field lol), and our company has email structure firstname.lastname@company.com.

 

So i'm trying to extract the first string (John) and second string (Smith) to formulate an email address, so that I can use in an email alert.  I know i will need to get this email into an email field but I figured I could do that with a workflow.

 

Any help would be great.

 

So far I have tried

TRIM(LEFT( CustomField__c , FIND(" ", CustomField__c)))

 

and I am able to get "firstname", however if I try

TRIM(RIGHT( CustomField__c , FIND(" ", CustomField__c)))

 it does not always get the last string after the space " ".

 

Help would be great in figuring this out!

 

Thanks in advance.

 

B2A

Ispita_NavatarIspita_Navatar

You say  - I have a text field that has full name Eg. John Smith

You want to contruct firstname.lastname@company.com

So the formula to get lastname should be  :-

RIGHT(CustomField__c,LEN(CustomField__c) - FIND(" ", CustomField__c)  )
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.