+ 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/)