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
Ankit DableAnkit Dable 

I want to separate the string from the Text field using formula. Example textfield =TestName,TestCity,TestCountry

I want to separate the string from the Text field using formula. Example textfield =TestName,TestCity,TestCountry
and I want to separate the string as
Name__c=TestName
City__C=TestCity
Country__c=TestCountry
Please assist me to make formula for this.
Best Answer chosen by Ankit Dable
Akshay_DhimanAkshay_Dhiman
 Hi
 Ankit Dable,
   
  Extract separate First and Last Names from a text field containing Full Name?

  To separately extract first and last name values or both segments of any other two-part string like street number and street name use the following formulas in 2 separate Formula (text data type) fields

 First Name:

 LEFT(FirstLastName__c,FIND(" ,", FirstLastName__c))

 Last Name:

 RIGHT(FirstLastName__c, LEN(FirstLastName__c) - FIND(", ", FirstLastName__c))


 Assuming there is a space between First and Last names (or any other two-part string) the formulas are based on all
 characters to the left of the space, and all characters to the right of the space, respectively.
       
      
 if you found this answer helpful then please mark it as best answer so it can help others.   

   Thanks 
   Aksay