Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jonathan Kim 22Jonathan Kim 22 

Edit Row-Level Formula

I need to substring data from a field to insert into an Row-Level formula on a report. Example of the field's data looks like this:

"Tom Smith time of 600s on 2022-10-04"

This is the field name: LWCCaseTimer__Session_Time__c.Name

How would I substring out the name "Tom Smith" before the position of the word "time"? The length of the name in the field can be different for each record.
Best Answer chosen by Jonathan Kim 22
SteveMo__cSteveMo__c
So like this? 
  
LEFT( LWCCaseTimer__Session_Time__c.Name, FIND( ' time' , LWCCaseTimer__Session_Time__c.Name ))


 

All Answers

SteveMo__cSteveMo__c
So like this? 
  
LEFT( LWCCaseTimer__Session_Time__c.Name, FIND( ' time' , LWCCaseTimer__Session_Time__c.Name ))


 
This was selected as the best answer
Jonathan Kim 22Jonathan Kim 22
Thank you! That works perfectly.