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
bhanu_prakashbhanu_prakash 

how to get only second text

How can i get only text from words
EX:  Sultan Road
output : Road
Best Answer chosen by bhanu_prakash
Harshit Garg 6Harshit Garg 6
Hi bhanu,

if you are using formula field. Please use that below formula.
 
RIGHT( your_field_Name , LEN(your_field_Name) - FIND(" ", your_field_Name))

Thanks,
Harshit Garg

All Answers

Rakesh Thota 13Rakesh Thota 13
H Bhanu,

Can you please elaborate what exactly you want to achieve, Accordingly I can Help you.
 
Best Regards,
Rakesh Thota
bhanu_prakashbhanu_prakash
in Street name field we have Sultan Road, i need to seperate Road and need to ouput road is automaticlly
GauravGargGauravGarg

Hi Bhanu,

You can use String Class method to split the word in two and get subString like below:
 

String s1 = 'Force.com platform'; 
String s2 = s1.substringAfterLast(' '); 
System.assertEquals( 'platform', s2);
 



for more information on String class, visit
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_string.htm


Hope this helps!!!

Thanks,
Gaurav
 

Harshit Garg 6Harshit Garg 6
Hi bhanu,

if you are using formula field. Please use that below formula.
 
RIGHT( your_field_Name , LEN(your_field_Name) - FIND(" ", your_field_Name))

Thanks,
Harshit Garg
This was selected as the best answer
Rajat raiRajat rai
You can visit here for more information https://fullwikibio.com/mo-vlogs-biography/
Sargam SinghSargam Singh
You must visit here for more info Shehnaz Gill Wiki (https://wikibioage.in/shehnaz-kaur-gill/)
yaw lateefyaw lateef
Have you tried checking on checking second text (http://trytutuapp.com) via textnow (http://amazonprimefirestick.com)?
Joe Miller 21Joe Miller 21
Harshit Garg thanks, that helped. best regards papers due (https://paper-due-now.com/)
ken war 8ken war 8
Online billings platforms help you to save time and money as well. These online billing platforms make our life much more comfortable. Peryourhealth may be a popular and trusted method to save lots of oneself from such agony. The Peryourhealth login web portal gives an easy way to pay the bills online without any worry. https://peryourhealth.fun