You need to sign in to do that
Don't have an account?
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
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.